Validate VBA drop down on click

Question

I have a drop down select list in a VBA form I would like to validate as soon the user clicks on it. It needs to check that a pre-requisite drop down has been filled already.

This is to avoid the user jumping ahead on the form because there are certain fields that need to be filled out first. My attempt so far is not working:

Private Sub cbo_moduleName_Click() If Len(cbo_moduleCode.Value) = 0 Then MsgBox ("Please select a module code") Exit Sub End If End Sub

What is cbo_moduleCode on your UserForm? What error message you getting? Can you provide a screenshot of your UserFrom? — brettdj
– brettdj, Commented Oct 27, 2012 at 11:31
Oops my bad. I had posted an answer for you but then realized I was using VB6, not VBA. — Boann
– Boann, Commented Oct 27, 2012 at 11:36
@Boann your answer is correct, in vba the only diff is the event is named cbo_moduleName_Enter not cbo_moduleName_GotFocus() — Alex K.
– Alex K., Commented Oct 27, 2012 at 11:37
@brettdj cbo_moduleCode is a dropdown menu in my form. Here is a picture i46.tinypic.com/okwwut.png — methuselah
– methuselah, Commented Oct 27, 2012 at 11:40
@AlexK Er I'll undelete it then, but Excel is crashing when I try it so I dunnoo. — Boann
– Boann, Commented Oct 27, 2012 at 11:40

Boann · Accepted Answer · 2012-10-27 11:42:20Z

It seems the Click event is activated only when the box's value is changed with the mouse, not every time it is physically clicked on. Try this:

Private Sub cbo_moduleName_Enter() If Len(cbo_moduleCode.Value) = 0 Then MsgBox ("Please select a module code") cbo_moduleCode.SetFocus Exit Sub End If End Sub

Collectives™ on Stack Overflow

Validate VBA drop down on click

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related