Excel VBA Dropdown

[eilob]

Hi all,

I need to set up the properties of a dropdown list equal to nothing, so that when I open my workbook nothing is selected. I dont want anything to show on the dropdown..
So I need to place this code on a form so will have to specify the name of the Sheet first and then the name of the dropdown like:

Sheets("Revenue").DropdownRegion.Value = ""

This doesnt work but will be something like that?

Thanks in advance

eilob

 

[SkipVought]

Hi,

What version of Excel?

I assume that the dropdown is on your Sheet and not on a UserForm, yes?

What kind of dropdown?

1. Data Validation
2. MS Forms
3. Control Toolbox



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[combo]

For MSForms listbox:

Sheets("Revenue").DropdownRegion.ListIndex=-1

combo

 

[fumei]

I think you need to make an empty item.

Gerry

 

[eilob]

Hi, The dropdown is a control toolbox...

 

[fumei]

Please be clear. It always helps.

So...it is a control toolbar ComboBox. Not a "dropdown".

so that when I open my workbook nothing is selected. I dont want anything to show on the dropdown..

How have you populated it? Because, normally, you should be getting anything there. It should, in fact, be exactly as you state you want it to be. If you do not specify a ListIndex, then it should start out blank. So please describe, exactly, what you have done with this control.

Gerry