Forum Home
Press F1
Thread ID: 11935	2001-10-10 01:51:00	VBA Question	Guest (0)	Press F1

Post ID	Timestamp	Content	User
20850	2001-10-10 01:51:00	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	Guest (0)
20851	2001-10-10 05:47:00	What program are you talking about here? Try hitting the Tab key, instead of enter and see if that works for you.	Guest (0)
20852	2001-10-10 08:15:00	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	Guest (0)
1