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