Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
enter into an excel cell...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
enter into an excel cell...
Mark,
Use SendKeys. E.g., ActiveCell.Value = "=" SendKeys "{F2}" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mark" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
enter into an excel cell...
Sub AAA()
Application.SendKeys "{f2}=" End Sub Regards, Tom Ogilvy Mark wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) |