View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ilia ilia is offline
external usenet poster
 
Posts: 256
Default 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.