Userform ComboBox enabling textboxes

Question

I have a userform with a combobox and multiple textboxes. I used the BeforeUpdate event for the combobox to determine which boxes in the field were enabled at a given time. The problem I have is, everytime I change the combobox the boxes aren't enabled or disabled until I click on one of them. Is it possible to refresh all of the boxes after the combobox selection is made? I've included a sample of the code I'm using; there are 27 textboxes that are enabled or disabled depending on 6 different combobox options.Thanks!

Private Sub AdminCombo_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If AdminCombo = "Composite" Then
        AdminCompCurr.Enabled = True
        AdminCompRenNum.Enabled = True
        AdminCompRenPer.Enabled = True
        AdminEEOnlyCurr.Enabled = False
        AdminEEOnlyRenNum.Enabled = False
        AdminEEOnlyRenPer.Enabled = False
    End If
End Sub

What happens if you use the AdminCombo_AfterUpdate event instead? — guitarthrower
– guitarthrower, Commented Jan 17, 2014 at 21:01
Thanks! It actually didn't help it, but I tried AdminCombo_Change() event and it worked perfectly. — kcraig23
– kcraig23, Commented Jan 17, 2014 at 22:03

guitarthrower · Accepted Answer · 2014-01-20 17:34:05Z

1

So we have the answer here for future use.

Change the line:

Private Sub AdminCombo_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)

to

Private Sub AdminCombo_Change(ByVal Cancel As MSForms.ReturnBoolean)

This uses the event after the combobox is changed to update the needed textboxes.

answered Jan 20, 2014 at 17:34

guitarthrower

5,9143 gold badges33 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Userform ComboBox enabling textboxes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related