Combo Box Within A Cell

[Nathan]

Hi! Can someone tell me how I can have a combo box
included somehow within a cell? I've seen a spreadsheet
that has a drop down facility within a cell that doesn't
seem to be a normal combo box but lists the information
the same way. The beauty of it is that you don't have
the 'bulk' of a normal combo box if you want to use them
within many rows of a data entry sheet.

Any ideas appreciated!

 

[John Wilson]

Nathan,

What you're probably thinking of is Data Validation.

Check here for some examples and instructions:

http://www.contextures.com/xlDataVal01.html

If that's not what you're looking for, post back.

John

 

[Nathan]

I can respond to myself! People should really search on
problems before posting new ones shouldn't they

The resolution is to create a validation within the
cell, 'Data/Validation' - really excellent option as you
can either link it to a list or create your own list
within the validation option box.

Continuing in my belief that Excel is THE best program
ever written!!