Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form - How to store data on press of enter key.
I want to create a user form with a text box that you type in the data and press enter and the data is stored in a set cell, then the form automatically clears and you type the next bit of data in the same text box, press enter and the data is saved in the next cell down and so on. I can create the form and text box but need the code. The only example I could find needed a commandbutton to be clicked to store the data. I want to cut out this step. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form - How to store data on press of enter key.
No need to multi post, you have an answer in your other thread in general Questions "NDBC" wrote: I want to create a user form with a text box that you type in the data and press enter and the data is stored in a set cell, then the form automatically clears and you type the next bit of data in the same text box, press enter and the data is saved in the next cell down and so on. I can create the form and text box but need the code. The only example I could find needed a commandbutton to be clicked to store the data. I want to cut out this step. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form - How to store data on press of enter key.
Sorry, I won't make the same mistake again. "Mike H" wrote: No need to multi post, you have an answer in your other thread in general Questions "NDBC" wrote: I want to create a user form with a text box that you type in the data and press enter and the data is stored in a set cell, then the form automatically clears and you type the next bit of data in the same text box, press enter and the data is saved in the next cell down and so on. I can create the form and text box but need the code. The only example I could find needed a commandbutton to be clicked to store the data. I want to cut out this step. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user form - how to set it up so it stores data when you press ente | Excel Discussion (Misc queries) | |||
Excel user enter a store # to query Access data base | Excel Discussion (Misc queries) | |||
Close form when I press enter | Excel Programming | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Enter data and press enter to move to specific cell | Excel Programming |