Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rachel
 
Posts: n/a
Default Pressing Enter/Tab to go next question in a form

I inherited an Excel form that my boss would like made into a company-wide
template. It's in a pretty rough state right now, but the primary request on
this form is,"Can I just hit Enter or Tab to go to the next part I need to
fill out?"
I've done some research, but your help would be appreciated.
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Rachel

What type of forms?

Just worksheet cell selections?

There are several ways to set the TAB order on worksheet cells.

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA event code.

If interested, post back for more detail and some sample code.


Gord Dibben Excel MVP

On Mon, 26 Sep 2005 08:47:02 -0700, Rachel
wrote:

I inherited an Excel form that my boss would like made into a company-wide
template. It's in a pretty rough state right now, but the primary request on
this form is,"Can I just hit Enter or Tab to go to the next part I need to
fill out?"
I've done some research, but your help would be appreciated.


  #4   Report Post  
Rachel
 
Posts: n/a
Default

Hi Gord,
Sorry for the delay in responding to your questions, but thank you for your
help: This is a seven page Excel workbook of order forms, product info, etc.
that we want our reps to complete via the computer.
I may have confused anyone trying to help me by throwing the word "Tab" in
there. I was asked if after entering one piece of information could the rep
just press a key to move to the next field needing info (I originally used
the words "Tab/Enter" instead of "any key").
Between the originator of my "inheritied form" and my "expertise", we are
like the blind leading the blind...not much of a clue on how to do this!
So...again, your help is GREATLY appreciated.

Rachel
P.S. Went to the link you sent and learned a lot, but still so much to learn-

"Gord Dibben" wrote:

Rachel

What type of forms?

Just worksheet cell selections?

There are several ways to set the TAB order on worksheet cells.

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA event code.

If interested, post back for more detail and some sample code.


Gord Dibben Excel MVP

On Mon, 26 Sep 2005 08:47:02 -0700, Rachel
wrote:

I inherited an Excel form that my boss would like made into a company-wide
template. It's in a pretty rough state right now, but the primary request on
this form is,"Can I just hit Enter or Tab to go to the next part I need to
fill out?"
I've done some research, but your help would be appreciated.



  #5   Report Post  
Rachel
 
Posts: n/a
Default

Thank you, Kassie, for your help. Unfortuantely, I don't think I explained
myself too well. I've unlocked the cells so they can enter info but they
want to move forward in the form w/o having to find the correct cell to enter
the next information-just pressing any key to take them to the next area to
complete.
Thanks again, Kassie, for trying to help. I'm trying all suggestions and am
I ever learning a lot!! There is soooo much to know...you folks just amaze
me! Thanks again-

Rachel

"Kassie" wrote:

Hi Rachel.

You do that by unlocking the cells you want to allow access to, protecting
the sheet, and allowing users to only select unlocked cells
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Rachel" wrote:

I inherited an Excel form that my boss would like made into a company-wide
template. It's in a pretty rough state right now, but the primary request on
this form is,"Can I just hit Enter or Tab to go to the next part I need to
fill out?"
I've done some research, but your help would be appreciated.

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
Creating a form question [email protected] Excel Discussion (Misc queries) 0 September 11th 05 10:48 PM
Worksheet form design rgarber50 Excel Discussion (Misc queries) 4 August 7th 05 05:09 AM
VBA Form Combo Box question. WTG Excel Discussion (Misc queries) 3 February 26th 05 05:28 PM
VBA Form ComboBox question WTG Excel Worksheet Functions 3 February 26th 05 05:27 PM
Trying to delete form border, and it deletes all borders PeterM Excel Discussion (Misc queries) 11 January 3rd 05 04:36 PM


All times are GMT +1. The time now is 12:04 PM.

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

About Us

"It's about Microsoft Excel"