Listbox/Form question

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

Can the selection of an item in a Listbox be
used to trigger another form where perhaps
further options could be presented, after
which the user would be returned to the
original form?

Regards.
 
Many thanks, will investigate.

Regards.

Dave Peterson said:
Option Explicit
Private Sub ListBox1_Change()
Me.Hide
UserForm2.Show
Me.Show
End Sub

Depending on what you're doing, you may want to look at designing your form
using multipage controls--like a lot of the builtin dialogs. So if the user
needs an option, they select that page and specify everything they need there.
Click to expand...
 
Back
Top