Can't edit Combo Box

[Brad]

Thanks for taking the time to read my question.

I have an Excel sheet that I need to edit. I have
unprotected the worksheet, and am able to right mouse
click on some of the combo boxes to edit them, but some
of them I can't right mouse click on.

Is this a common problem?
Any suggestions on a soultion?

Thanks again,

Brad

 

[kkknie]

There are two types of comboboxes, and it appears you have some o
each.

The one from the forms toolbar can be editied by right-clicking.

The one from the controls toolbar is an Active-X control. You mus
first be in design mode (from the Controls Toolbar select design mode)
Then you can right click and select format the control (which doesn'
do much) or select Properties and modify the properties of th
control.

 

[Brad]

Wow!

Thanks so much for your help. You were bang on.

Brad