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