edit combobox

M

mdecocq

Hello!

Just joined this usergroup, it has been very helpfull so far! Still
I've got a question.
I got a sheet with a combo box in it and I cannot edit the thing. When
I use right mouse-click I just get the standard menu that you get with
every cell, but I am supposed to get the editing part for the combo box
as well.

Anyway I think it has been locked somehow......any suggestions to solve
this?

Thanks in advance,

Martijn
 
D

Dave Peterson

There are three different things that look like comboboxes.

1. Data|Validation (from the worksheet menubar)
2. DropDowns from the Forms toolbar
3. Comboboxes from the control toolbox toolbar

Since you get the standard "cell" popup, I'm gonna guess that you have
Data|Validation.

See Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html
for tons of info

If it's really a Dropdown, make sure the worksheet is unprotected
(tools|protection). You can get the cell popup that way, too.

Same thing if it's from the controltoolbox toolbar (if you're not too accurate
with your rightclick!). But to edit a combobox properties, you'll have to show
the controltoolbox toolbar and go into design mode (top left icon), then right
click, properties.
 
M

mdecocq

Thanks for the info!

I'm going to try and fix this next week, first enjoy the Christmas
days....

Greets Martijn
 
Top