Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a series of text boxes that require data entry. box1, box2,... box 5.
I would like to be able to select cell 1 then enter data and hit the enter or tab key then have it progress to box 2... etc.etc.. to box 5.. any suggestions. I have looked at the text box properties and have not figured this out. thanks dr chuck |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() dr chuck wrote: I have a series of text boxes that require data entry. box1, box2,... box 5. I would like to be able to select cell 1 then enter data and hit the enter or tab key then have it progress to box 2... etc.etc.. to box 5.. any suggestions. I have looked at the text box properties and have not figured this out. thanks dr chuck check out the tabindex ..in the textbox properties. then you can just TAB you way through...for each textbox set the indeax as the number in the order you want |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
thanks steve... will give that a whirl
-- dr chuck "stevebriz" wrote: dr chuck wrote: I have a series of text boxes that require data entry. box1, box2,... box 5. I would like to be able to select cell 1 then enter data and hit the enter or tab key then have it progress to box 2... etc.etc.. to box 5.. any suggestions. I have looked at the text box properties and have not figured this out. thanks dr chuck check out the tabindex ..in the textbox properties. then you can just TAB you way through...for each textbox set the indeax as the number in the order you want |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation for a single text entry | New Users to Excel | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
How do I protect a text box, but allow entry of data | Excel Worksheet Functions | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions |