edit combobox

  • Thread starter Thread starter mdecocq
  • Start date Start date
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
 
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.
 
Thanks for the info!

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

Greets Martijn
 
Back
Top