Excel 2000 - can't find form control code

[Saxie1]

I have inherited someone elses spreadsheet. It has a bunch of comboboxes embedded in it, but right clicking on the combobox doesn't do anything. Even in VBA edit mode I still can't get to the code. I'm pretty sure they are form controls and not active-X.
I can insert a new combobox, right click and get the code edit box. Where the heck is the code for the existing comboboxes??
Please help ;-(

thanks in advance

 

[Dreamboat]

Are you in design view when you try to edit those existing ones? On the control toolbox, there's a design view button; make sure it's on. Then double-click or right-click the control.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[Saxie1]

Thanks Dreamboat,
yes I have tried it in design view. Nothing happens when I right click or double click. I can create a new combo box and edit the code no problem I just can't get to the existing combo box code. The spread sheet is not protected. I'm usually pretty good at figuring out this kind of stuff, but this one has me stumped.

I'll keep messing with it.

Saxie1