Adding an Active X control to a cell

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

Guest

I would like to add a drop down lists to a bunch of cells. The control adds a box over the top of all the cells, trying to size it so that it fits over the top of the cell seems to be a rather inaccurate method of doing it.
 
Hold down alt while you place it in the cell and it will fit the cell

--

Regards,

Peo Sjoblom


Rick said:
I would like to add a drop down lists to a bunch of cells. The control
Click to expand...
adds a box over the top of all the cells, trying to size it so that it fits
over the top of the cell seems to be a rather inaccurate method of doing it.
 
Rick
Check out Data>Validation on the pull down menu. This will set up a dropdown list directly in the cell

Good Luck
Mark Graesse
(e-mail address removed)

----- Rick wrote: ----

I would like to add a drop down lists to a bunch of cells. The control adds a box over the top of all the cells, trying to size it so that it fits over the top of the cell seems to be a rather inaccurate method of doing it.
 
Back
Top