PDA

View Full Version : VBA Question



10-10-2001, 02:51 PM
I am using Office 97 and in particular 97. I am trying to build a userform that can take information in several textboxes one listbox and one final command button which when the form is full with the final entry is transferred onto a spreadsheet. My problem is that I want to use the 'Enter' key for ease of entry - not the mouse - when the textbox is filled or the listbox item selected. This works fine for the textboxes but not the listbox. Using Up/Down keys I can select the item but then cannot use the Enter key to transfer control to the final command button. I can do this with the mouse but is there a way of doing this with the Enter key. Thanks

10-10-2001, 06:47 PM
What program are you talking about here?
Try hitting the Tab key, instead of enter and see if that works for you.

10-10-2001, 09:15 PM
Thanks Mike
yes you are right Tab does work - I must have tried most other keys but not that one - and I am using mainly Excel 97. Is there still a way of changing this to Enter key that you know of? Thanks