| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Execute vba code on cell exit
I came up with this much, but it does nothing. Help me please?
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static Oldselection As Range If Oldselection = "Meter Reading" Then SendKeys "{RIGHT 2}Bill Coyne{RIGHT}FM", True End If End Sub I want to fill in "Bill Coyne" two cells to the right and "FM" three cells to the right if the cell I exit equals "Meter Reading" Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to execute a formula copied into an excel cell | Excel Worksheet Functions | |||
| macros doesn't execute unless i go into cell and press enter. | Excel Discussion (Misc queries) | |||
| can i execute a calculation in a cell at a certain time of the day | Excel Worksheet Functions | |||
| how do you execute single line of code? | Excel Discussion (Misc queries) | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Threaded Mode
