View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hector Fernandez Hector Fernandez is offline
external usenet poster
 
Posts: 8
Default Combo Box vba that works like Forms Menu combo box

I've looked for quite some time for a solution, but can't seem to find
it.

All I want to do is make a combo box in an User Form that works just
like the combo box in the Forms toolbar.

I can get the User Form combo box to show a range of options from which
to choose from (same as the Input Range Control for the combo box in
Forms, but I can't for the life of me figure out how to get it to
simply put in a number in a linked cell (as the Forms toolbox does).

With forms, the selection you make puts a number, depending on the
combo box choice, in the Linked Cell of my choice. I want to do
exactly the same thing with the User Form combo box - HELP