Combobox

[ServiceChris]

Hi all. I'm back with my 3rd query this week - I didn't realise ho
little I knew!!

Anyway, here goes. I have a spreadsheet with several simple dropdow
list in it. However, I would like the added functionality of the comb
boxes, especially the ability to find items as each letter is typed (
personally hate using the mouse, and the quicker I can do things vi
the keyboard, the better - so lazy)

Anyway, I can create a combobox with no problem (from the contro
toolbox). I can get it to display the correct range of data. However
it just seems to float above the actual cell I want it to be in.
don;t want the user to know they have a combobox working in th
background. So, for example, they enter their name in cell B4, the
tab or enter to move to cell B5, which should have a combo box in it.
But they actually arrive behind the box (even though it completel
fills the cell)

What am I doing wrong!!!

Thanks in advance.

Chri

 

[Vasant Nanavati]

Controls always "float" above a cell. They cannot be "in" a cell even if
they may appear to be.

If you want the drop-down to be integrated with the cell, you may want to
look at Data Validation,