combo box

[mikk]

Is it possible to create a combo box within a cell? I
have a series of records and in column F I would like a
combo box that i can copy down for future records. Any
thoughts?

 

[Kevin M]

Mikk,

You could use data validation in the column you want the
combo box in. create a list of what may go into the cell
elsewhere on the SAME page (hide it if you want to, but
it must be on the same page), then point the Data
Validated target to your list. you may also want to see
the link below about creating a dynamic list so that when
you add to it you don't have to adjust your validation
cells.
HTH
Kevin M

http://www.contextures.com/xlNames01.html#Dynamic

 

[Mikk]

Yep, that is exactly what I wanted. TY

-----Original Message-----
Mikk,

You could use data validation in the column you want the
combo box in. create a list of what may go into the cell
elsewhere on the SAME page (hide it if you want to, but
it must be on the same page), then point the Data
Validated target to your list. you may also want to see
the link below about creating a dynamic list so that when
you add to it you don't have to adjust your validation
cells.
HTH
Kevin M

http://www.contextures.com/xlNames01.html#Dynamic
.

 

[Bob Phillips]

Mikk,

Comboboxes are separate from cells. You can size it to fit in a cell, but it
doesn't copy if you copy a cell and paste it to another. If you want more
comboboxes

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)