| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving through a data entry form
I am trying to create a form that will take the user to the next fiel
after entering data. I have tried to record a macro using "Got Reference", but it doesn't stop and wait for user input. I need bot the event procedure and the correct format for incorporating it int the macro. thank you -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moving through a data entry form
There is no provision in Excel VBA to stop and wait while the user enters
something in a cell. You will need to prompt with an input box or userform to get the input, then place it in the cell with your code. An Alternative is to halt the macro and try to trap the activity of the user to determine when to continue. -- Regards, Tom Ogilvy jjankowski wrote in message ... I am trying to create a form that will take the user to the next field after entering data. I have tried to record a macro using "Goto Reference", but it doesn't stop and wait for user input. I need both the event procedure and the correct format for incorporating it into the macro. thank you! --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Entry Form | Excel Discussion (Misc queries) | |||
| How do I require data entry in a cell before moving to the next ce | Excel Worksheet Functions | |||
| moving data from a form to another sheet | Excel Worksheet Functions | |||
| data entry form | Excel Discussion (Misc queries) | |||
| Data Entry on a Form | Excel Programming | |||
Hybrid Mode
