Adding an Active X control to a cell

R

Rick

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.
 
P

Peo Sjoblom

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.
 
M

Mark Graesser

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
[email protected]

----- 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.
 
Top