Combo box that looks like a cell.

[Fraggs]

I have seen a spreadsheet that has a combo box that looks like a cel
and was wondering how this was achived?
Basically, when you look at it it contains data, you click it and
little drop down arrow appears, you click the arrow and all you
choices of data appear. can anyone explain to me how this is done?

Thanks

 

[Andy Brown]

Basically, when you look at it it contains data, you click it and a

little drop down arrow appears, you click the arrow and all your
choices of data appear. can anyone explain to me how this is done?

Data Validation - see http://www.contextures.com/xlDataVal01.html

Rgds,
Andy

 

[Andy B]

Hi

Have a look at Data Validation (Data / Validation !!). You can set various
options in there - including Select from list - and you can point it to an
existing list or create your own.

 

[Fraggs]

Cool, works a treat ... Taa very much :

 

[Bill Allen]

Hey, that's not fair!

Now, how am I going to justify writing code for a Combo Box?

)

Bill