Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Combobox options based on the input of another combobox | Excel Programming | |||
ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming |