Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
Hi,
This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
You can have as many as you like, but the latest one is the only one that
can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
Thanks for the reply Bob. I put this code in..........
Private Sub CommandButton3_Click() UserForm2.Show UserForm10.Show UserForm11.Show End Sub .........and each userform will only show after I close the first one. I have set the properties so they are all in different places on the sheet but I can't get them to show all at the same time? By the way user form 2 is the form I want to be active the other forms show data related to selections in form 2. Where am I going wrong? Many Thanks gregork "Bob Phillips" wrote in message ... You can have as many as you like, but the latest one is the only one that can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
Hi
You missed the "vbModeless" after Show Private Sub CommandButton3_Click() UserForm2.Show vbModeless UserForm10.Show vbModeless UserForm11.Show vbModeless End Sub Cheers, Flemming "gregork" wrote in message ... Thanks for the reply Bob. I put this code in.......... Private Sub CommandButton3_Click() UserForm2.Show vbmodeless UserForm10.Show vbmodeless UserForm11.Show vbmodeless End Sub ........and each userform will only show after I close the first one. I have set the properties so they are all in different places on the sheet but I can't get them to show all at the same time? By the way user form 2 is the form I want to be active the other forms show data related to selections in form 2. Where am I going wrong? Many Thanks gregork "Bob Phillips" wrote in message ... You can have as many as you like, but the latest one is the only one that can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
Thanks Flemming. Do you know how I could get all three forms to close when I
close form 2 ? Regards gregork "Flemming Dahl" wrote in message ... Hi You missed the "vbModeless" after Show Private Sub CommandButton3_Click() UserForm2.Show vbModeless UserForm10.Show vbModeless UserForm11.Show vbModeless End Sub Cheers, Flemming "gregork" wrote in message ... Thanks for the reply Bob. I put this code in.......... Private Sub CommandButton3_Click() UserForm2.Show vbmodeless UserForm10.Show vbmodeless UserForm11.Show vbmodeless End Sub ........and each userform will only show after I close the first one. I have set the properties so they are all in different places on the sheet but I can't get them to show all at the same time? By the way user form 2 is the form I want to be active the other forms show data related to selections in form 2. Where am I going wrong? Many Thanks gregork "Bob Phillips" wrote in message ... You can have as many as you like, but the latest one is the only one that can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
You can use the End command somewhere in your code on Userform2 like this
Userform10.End Userform11.End Cheers, Flemming "gregork" wrote in message ... Thanks Flemming. Do you know how I could get all three forms to close when I close form 2 ? Regards gregork "Flemming Dahl" wrote in message ... Hi You missed the "vbModeless" after Show Private Sub CommandButton3_Click() UserForm2.Show vbModeless UserForm10.Show vbModeless UserForm11.Show vbModeless End Sub Cheers, Flemming "gregork" wrote in message ... Thanks for the reply Bob. I put this code in.......... Private Sub CommandButton3_Click() UserForm2.Show vbmodeless UserForm10.Show vbmodeless UserForm11.Show vbmodeless End Sub ........and each userform will only show after I close the first one. I have set the properties so they are all in different places on the sheet but I can't get them to show all at the same time? By the way user form 2 is the form I want to be active the other forms show data related to selections in form 2. Where am I going wrong? Many Thanks gregork "Bob Phillips" wrote in message ... You can have as many as you like, but the latest one is the only one that can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
Whatever code that closes form2, should contain code to close forms 1 and 3.
-- Regards, Tom Ogilvy "gregork" wrote in message ... Thanks Flemming. Do you know how I could get all three forms to close when I close form 2 ? Regards gregork "Flemming Dahl" wrote in message ... Hi You missed the "vbModeless" after Show Private Sub CommandButton3_Click() UserForm2.Show vbModeless UserForm10.Show vbModeless UserForm11.Show vbModeless End Sub Cheers, Flemming "gregork" wrote in message ... Thanks for the reply Bob. I put this code in.......... Private Sub CommandButton3_Click() UserForm2.Show vbmodeless UserForm10.Show vbmodeless UserForm11.Show vbmodeless End Sub ........and each userform will only show after I close the first one. I have set the properties so they are all in different places on the sheet but I can't get them to show all at the same time? By the way user form 2 is the form I want to be active the other forms show data related to selections in form 2. Where am I going wrong? Many Thanks gregork "Bob Phillips" wrote in message ... You can have as many as you like, but the latest one is the only one that can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
If you want them modal,
show form1, in its activate event, have it show form3, in the activate event of form3, have it show form2 Private Sub Userform_Activate() ' form 1 code userform3.Show unload me End Sub Private Sub Userform_Activate() ' form 3 code userform2.Show unload me End Sub Private Sub Cmd_OK_Click() ' form 2 code unload me End Sub - add code to position the forms. -- Regards, Tom Ogilvy "gregork" wrote in message ... Thanks for the reply Bob. I put this code in.......... Private Sub CommandButton3_Click() UserForm2.Show UserForm10.Show UserForm11.Show End Sub ........and each userform will only show after I close the first one. I have set the properties so they are all in different places on the sheet but I can't get them to show all at the same time? By the way user form 2 is the form I want to be active the other forms show data related to selections in form 2. Where am I going wrong? Many Thanks gregork "Bob Phillips" wrote in message ... You can have as many as you like, but the latest one is the only one that can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
You need to trap the QueryClose event to trap all close situations, like so
in the Userform2 Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) Unload UserForm1 Unload UserForm3 End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Flemming Dahl" wrote in message ... You can use the End command somewhere in your code on Userform2 like this Userform10.End Userform11.End Cheers, Flemming "gregork" wrote in message ... Thanks Flemming. Do you know how I could get all three forms to close when I close form 2 ? Regards gregork "Flemming Dahl" wrote in message ... Hi You missed the "vbModeless" after Show Private Sub CommandButton3_Click() UserForm2.Show vbModeless UserForm10.Show vbModeless UserForm11.Show vbModeless End Sub Cheers, Flemming "gregork" wrote in message ... Thanks for the reply Bob. I put this code in.......... Private Sub CommandButton3_Click() UserForm2.Show vbmodeless UserForm10.Show vbmodeless UserForm11.Show vbmodeless End Sub ........and each userform will only show after I close the first one. I have set the properties so they are all in different places on the sheet but I can't get them to show all at the same time? By the way user form 2 is the form I want to be active the other forms show data related to selections in form 2. Where am I going wrong? Many Thanks gregork "Bob Phillips" wrote in message ... You can have as many as you like, but the latest one is the only one that can be active, unless .... As long as you have XL2000 up, make the calling form modeless (Userform2.show vbmodeless) and then you can switch between. Also, take a look at Chip's page as you will probably want to set the form position so that they start not overlaying each other http://www.cpearson.com/excel/FormPosition.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple user formshow
Thanks for all the replies guys. Everything's working perfectly.
Kind Regards gregork "gregork" wrote in message ... Hi, This may sound a little strange but is it possible to have 3 user forms showing on a sheet at the same time? If yes then how can I do it? Regards gregork |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple User issues | Excel Worksheet Functions | |||
Multiple user excel file | New Users to Excel | |||
Multiple user Time tracking | Excel Discussion (Misc queries) | |||
General multiple new user questions | New Users to Excel | |||
multiple user DB access via Excel (troubleshooting?) | Excel Programming |