A blank selection at the top of a User Form's drop down list.

[USAMax]

I need users to be able to clear a field without having to select the text and hitting the back space or delete.

When they clear the field I will remove the selection from the sheet using the change event from the combo box but if someone puts their curer in the box and removes one letter that triggers the event. I need a blank field they can select.

How can I add a blank selection at the top of the drop down list in the User Form?

 

[wigi]

How is the list populated right now?

 

[USAMax]

Hi wigi,

I am using the UserForm1.AddItem to add the users but adding a space has not been adding it in the drop down.

 

[dmt32]

I need users to be able to clear a field without having to select the text and hitting the back space or delete.

How can I add a blank selection at the top of the drop down list in the User Form?

As an example, see if this does what you want:

With Me.ComboBox1
        .AddItem vbNullString
        For i = 1 To 10
            .AddItem i
        Next i
    End With

Dave

 

[wigi]

As an example, see if this does what you want:

With Me.ComboBox1
        .AddItem vbNullString
        For i = 1 To 10
            .AddItem i
        Next i
    End With

Dave

Or:

ComboBox1.List = Split(" " & Join(Application.Transpose([row(1:10)])))

or:

ComboBox1.List = Split(" 1 2 3 4 5 6 7 8 9 10")

 

[USAMax]

That's fricken assume... I've seen somthing else done like that before but not in this context. Thanks Dave!

 

[USAMax]

Thank you Wigi, I have not had any luck using the split but I'll try it again.

 

[wigi]

Thank you Wigi, I have not had any luck using the split but I'll try it again.

That's good because for me it works fine.

 

[dmt32]

That's fricken assume... I've seen somthing else done like that before but not in this context. Thanks Dave!

Your welcome - As already shown, there are number of ways you can approach your requirment.

Thanks for feedback

Dave