Solved: Adding Combobox inside of Cell

[jimoo]

I want to put a combo list box in a cell with the following values, 'High' 'Medium' 'Low'

I may want others later with other values in the future.

I searched the knowlegdebase and didn't see anything like this, but I think I have seen spreadsheet with one before. I am not looking for a VBA form, but simply the combobox inside the cell.

Thanks in advance for your help.

:banghead:

[gibbo1715]

are you talking about Data Validation?

Try this

Select cell A1

Select data from top menu,

then validation

In the allow combo box select list

In the source text box type High,Medium,low

Now click ok and click on cell A1

Just drag down to add this to other cells

Gibbo

[jimoo]

Thanks, That solved the problem.

[gibbo1715]

Glad to help,

can I ask you mark the thread as solved please using thread tools at the top

cheers

Gibbo