Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default If Then Combobox

I have a combobox (rating) with the following list "G, PG, PG-13, R, NC-17,
X, NR". I want to be able to do the following: tab to rating, then
if "g" then select G and tab
if "p" then select PG and tab
if "3" then select PG-13 and tab
if "r" then select R and tab
if "7" then select NC-17 and tab
if "x" then select X and tab
if "n" then select NR and tab
where "g" means I press the g key, etc, and tab means whenever I select the
appropriate key the corresponding selection is made and automatically tabs to
the next combobox.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default If Then Combobox

Try using a select statement within the Keypress event of the Combobox.
Within each case set the Listindex of the Combobox to match the value.

If this post helps click Yes
---------------
Jacob Skaria


"Bishop" wrote:

I have a combobox (rating) with the following list "G, PG, PG-13, R, NC-17,
X, NR". I want to be able to do the following: tab to rating, then
if "g" then select G and tab
if "p" then select PG and tab
if "3" then select PG-13 and tab
if "r" then select R and tab
if "7" then select NC-17 and tab
if "x" then select X and tab
if "n" then select NR and tab
where "g" means I press the g key, etc, and tab means whenever I select the
appropriate key the corresponding selection is made and automatically tabs to
the next combobox.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default If Then Combobox

I'm sorry but I don't know what a "select statement", "Keypress event"
is/does. And I'm still a little fuzzy on what "Listindex" does or where it
is. Can you be more descriptive? Maybe give me an example?

"Jacob Skaria" wrote:

Try using a select statement within the Keypress event of the Combobox.
Within each case set the Listindex of the Combobox to match the value.

If this post helps click Yes
---------------
Jacob Skaria


"Bishop" wrote:

I have a combobox (rating) with the following list "G, PG, PG-13, R, NC-17,
X, NR". I want to be able to do the following: tab to rating, then
if "g" then select G and tab
if "p" then select PG and tab
if "3" then select PG-13 and tab
if "r" then select R and tab
if "7" then select NC-17 and tab
if "x" then select X and tab
if "n" then select NR and tab
where "g" means I press the g key, etc, and tab means whenever I select the
appropriate key the corresponding selection is made and automatically tabs to
the next combobox.

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
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
Combobox items determined by the selection in another combobox Alerion Excel Programming 2 September 13th 06 01:07 PM
Combobox options based on the input of another combobox afmullane[_5_] Excel Programming 1 May 3rd 06 01:44 PM
ComboBox list reliant on the entry from a different ComboBox ndm berry[_2_] Excel Programming 4 October 4th 05 04:40 PM
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox Minitman[_4_] Excel Programming 3 October 26th 04 07:58 PM


All times are GMT +1. The time now is 01:28 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"