MS Excel Combo Box

[Karthik]

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?

 

[Bob Phillips]

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)