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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

Many thanks, will investigate.

Regards.

"Dave Peterson" wrote in message
...
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.



Stuart wrote:

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.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

--

Dave Peterson



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003