If the code is in the Worksheet module and you created the dropdowns from the
Forms toolbar:

me.dropdowns("drop down 3").visible = ....

The Me keyword refers to the object that owns the code--in this case, it's the
worksheet.

There's a difference in behavior and code for dropdowns from the Forms toolbar
and comboboxes from the control toolbox toolbar.

And from the procedure names, it looks like you may have used comboboxes and
dropdowns on the same worksheet.

Johanna Gronlund wrote:

Hi,

I checked the names and they are Drop Down 3 and Drop Down 4 but it still
doeesn't work. Do I need to use:
'Drop Down 3'.visible = False
"Drop Down 3".visible = False
(Drop Down 3).visible = False
Drop Down 3.visible = False
or something else?

Sorry for being such beginner...!

--
Johanna

"BlackSun" wrote:

Il 08/02/2010 14.05, Johanna Gronlund ha scritto:
Thanks, I think that is exactly what I need to do. However, I am not able to
refer to the right combobox. How do I do that? I tried various things
including
combobox(Drop Down 3).visible=false but they just stopped the whole code
from working.

Sorry for being so ignorant. I am a total beginner with VB.

Thanks!


Hi,
select the control and see the name in the property tab; then write the
name and add .visible = False.

Let me know if you resolve :-)

--
Ciao BlackSun
.


--

Dave Peterson