Hello!

I have an Excel vba form with:

  • a set of textboxes and comboboxes
  • a set of buttons

The values entered in one subset from the textboxes and comboboxes (two of them) should define a 'mode' for the form. Depending of the values of that subset:

  • some textboxes and comboboxes need to be enabled or disabled (maybe even hide)
  • some buttons need to be enabled or disabled (maybe even hide)
  • the tab sequence for textboxes, comboboxes and buttons may be redefined
  • a certain textbox, combobox or buton should get the focus.

I already understand I can't do those actions within the code for the AfterUpdate event... but then, how can I implement that?

Thanks a lot!