Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying J Walkenbach's data entry userform
I have purchased the code for the data entry form from j-walk. I have
make a few small changes to the code. I am generally happy with the form. However, when the enter key is pressed during the entry of a new record. the form closes and returns to the spreadsheet database. I would appreciates any suggestions on how to make the enter key respond the same as the tab key; that is, move to the next control in the form. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying J Walkenbach's data entry userform
I don't remember what the Data Entry form looks like (been a while),
but if you set the textboxes' EnterKeyBehavior property to False, then Enter will act as Tab. Right-click on the form control in question, and select Properties from the pop-up menu. On Dec 10, 3:07 pm, rbl wrote: I have purchased the code for the data entry form from j-walk. I have make a few small changes to the code. I am generally happy with the form. However, when the enter key is pressed during the entry of a new record. the form closes and returns to the spreadsheet database. I would appreciates any suggestions on how to make the enter key respond the same as the tab key; that is, move to the next control in the form. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying J Walkenbach's data entry userform
You also may want to look to see if the Ok button's .default property is set to
true. If it is, then hitting enter is like clicking that button. rbl wrote: I have purchased the code for the data entry form from j-walk. I have make a few small changes to the code. I am generally happy with the form. However, when the enter key is pressed during the entry of a new record. the form closes and returns to the spreadsheet database. I would appreciates any suggestions on how to make the enter key respond the same as the tab key; that is, move to the next control in the form. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform data entry into hidden sheets | Excel Programming | |||
userform data entry | Excel Programming | |||
Userform: listbox and controls' data entry validation | Excel Programming | |||
data entry with userform questions | Excel Programming | |||
Creating a Data Entry Userform | Excel Programming |