Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop a macro to enter data to the cell I want
Hi! If I wrote an Excel macro which runs and calculates until it meets a cell, lets call it c78, and it continues running and calculating as I wrote it to do, but I would like it to stop and wait for data to be entered on cell c78 which is one of the cells it passes on the run, what should I do? I believe it could be done in VB language. Ihuda *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop a macro to enter data to the cell I want
You are probably trying to use old lotus procedures. Probably could be a LOT easier. Why not post your code for comments. -- Don Guillett SalesAid Software "Ihuda Bunzl" wrote in message ... Hi! If I wrote an Excel macro which runs and calculates until it meets a cell, lets call it c78, and it continues running and calculating as I wrote it to do, but I would like it to stop and wait for data to be entered on cell c78 which is one of the cells it passes on the run, what should I do? I believe it could be done in VB language. Ihuda *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop a macro to enter data to the cell I want
Ihuda,
VBA code cannot run when the user is in Edit Mode, i.e. entering data in a cell. The closest you could get would be to run you code and when the cell in question reached, exit the routine. Do While SomeValue=true if activecell.value="" then sendkeys "{F2}" exit sub end if Loop But as the other replies have pointed out there are probably better ways of achieving you goal. NickHK "Ihuda Bunzl" wrote in message ... Hi! If I wrote an Excel macro which runs and calculates until it meets a cell, lets call it c78, and it continues running and calculating as I wrote it to do, but I would like it to stop and wait for data to be entered on cell c78 which is one of the cells it passes on the run, what should I do? I believe it could be done in VB language. Ihuda *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
Pause Macro to enter data in cell | Excel Programming | |||
Pause Macro to enter data in cell | Excel Programming |