View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anand Anand is offline
external usenet poster
 
Posts: 13
Default preselecting in combo box

I'm having a userform which on initialization should select one of the
values in the combo box control. This selection should be based on the
value of particular cell.
For example, if cell (B11) = 20, the selected value in comboBox upon
initializatino should be 20 which is second entry in the complete list
of (10,20,30,40).
Please suggest solution for this.
Appreciate any help.

thanks,
Anand.