enter into an excel cell...

[Mark]

hi

i'm trying to creat a simple routine, that works off a
toolbar button, all i want it to do is put an equals
sign '=' in the active cell and make it active so i can
use the number pad. i've got the equals thing worked out
activecell.value = "=", but the problem is trying to make
the cell active, so when i type in numbers, it doesn't
overwrite my equals sign

any help would be great

cheers

mark

 

[Chip Pearson]

Mark,

Use SendKeys. E.g.,


ActiveCell.Value = "="
SendKeys "{F2}"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Tom Ogilvy]

Sub AAA()
Application.SendKeys "{f2}="
End Sub


Regards,
Tom Ogilvy