MS Excel Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a Combo Box which have drop down numbers, 1-5.
I would know like to select any one of the five and it should be displayed
in the required cell.
Is this possible and how?
 
Link a cell to the combobox. If it is a forms toolbar combo, right-click it
and select Format Control, select the Control tab and define the cell there.
If it is a control toolbar combo, go to design mode (the blue-green triangle
button), double-click the control which takes you into the VBIDE. make sure
the properties window is open (F4), and set the LinkedCell property.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top