Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default text box data entry

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 195
Default text box data entry


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default text box data entry

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data validation for a single text entry MZ New Users to Excel 8 January 27th 10 09:57 PM
Auto entry of data based on entry of text in another column or fie Judy Rose Excel Discussion (Misc queries) 2 May 21st 08 01:14 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing [email protected] Excel Discussion (Misc queries) 0 March 20th 08 12:45 PM
How do I protect a text box, but allow entry of data Bob Excel Worksheet Functions 0 October 18th 07 08:10 PM
Cell Entry That Locks Selected Cells From Any Data Entry. ron Excel Worksheet Functions 5 February 16th 07 09:52 PM


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"