View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
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.