Listbox/Form question

[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.

 

[Stuart]

Many thanks, will investigate.

Regards.

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.