Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
Excel 2003 Win XP
I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
Is it necessary for both userforms to be open at the same time?
If so, you might play around with their positions when they are initialized. Or maybe you should consider a different type of Userform control (page or tab feature) to encase everything you need on the main form. If it is not necessary for them both to be open at the same time, I would highly recommend hiding one whenever the other is initialized. Mark "donwb" wrote in message ... Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
Hi Mark
Thanks for the response. That's the "guaranteed" fix. But I had hoped to keep the main form visible all the time. There must be some way....... donwb "Mark Ivey" wrote in message ... Is it necessary for both userforms to be open at the same time? If so, you might play around with their positions when they are initialized. Or maybe you should consider a different type of Userform control (page or tab feature) to encase everything you need on the main form. If it is not necessary for them both to be open at the same time, I would highly recommend hiding one whenever the other is initialized. Mark "donwb" wrote in message ... Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
Have you played around with the FOCUS features?
Mark "donwb" wrote in message ... Hi Mark Thanks for the response. That's the "guaranteed" fix. But I had hoped to keep the main form visible all the time. There must be some way....... donwb "Mark Ivey" wrote in message ... Is it necessary for both userforms to be open at the same time? If so, you might play around with their positions when they are initialized. Or maybe you should consider a different type of Userform control (page or tab feature) to encase everything you need on the main form. If it is not necessary for them both to be open at the same time, I would highly recommend hiding one whenever the other is initialized. Mark "donwb" wrote in message ... Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
I did try to set the focus on the smaller UserForm but
UserFormXX.SetFocus was rejected. Then I tried to set the focus to one of the form's controls, as in UserFormXX.CommandButtonYY.SetFocus and although that was accepted, the UF stayed hidden behind the large one. donwb "Mark Ivey" wrote in message ... Have you played around with the FOCUS features? Mark "donwb" wrote in message ... Hi Mark Thanks for the response. That's the "guaranteed" fix. But I had hoped to keep the main form visible all the time. There must be some way....... donwb "Mark Ivey" wrote in message ... Is it necessary for both userforms to be open at the same time? If so, you might play around with their positions when they are initialized. Or maybe you should consider a different type of Userform control (page or tab feature) to encase everything you need on the main form. If it is not necessary for them both to be open at the same time, I would highly recommend hiding one whenever the other is initialized. Mark "donwb" wrote in message ... Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
What about the SHOWMODAL properties? Maybe they can help with this
problem... Mark "donwb" wrote in message ... I did try to set the focus on the smaller UserForm but UserFormXX.SetFocus was rejected. Then I tried to set the focus to one of the form's controls, as in UserFormXX.CommandButtonYY.SetFocus and although that was accepted, the UF stayed hidden behind the large one. donwb "Mark Ivey" wrote in message ... Have you played around with the FOCUS features? Mark "donwb" wrote in message ... Hi Mark Thanks for the response. That's the "guaranteed" fix. But I had hoped to keep the main form visible all the time. There must be some way....... donwb "Mark Ivey" wrote in message ... Is it necessary for both userforms to be open at the same time? If so, you might play around with their positions when they are initialized. Or maybe you should consider a different type of Userform control (page or tab feature) to encase everything you need on the main form. If it is not necessary for them both to be open at the same time, I would highly recommend hiding one whenever the other is initialized. Mark "donwb" wrote in message ... Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
Mark got the right answer, when showing the second form, set it to modal
Private Sub CommandButton1_Click() UserForm2.Show vbModal End Sub "donwb" wrote: Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
Thanks Patrick & Mark
Setting the forn to ShowModal=True solved it. donwb "Patrick Molloy" wrote in message ... Mark got the right answer, when showing the second form, set it to modal Private Sub CommandButton1_Click() UserForm2.Show vbModal End Sub "donwb" wrote: Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Userform
Glad to help out...
I was just guessing from my experiences, but Patrick provided the real fix... thanks for you input Patrick. Mark "donwb" wrote in message ... Thanks Patrick & Mark Setting the forn to ShowModal=True solved it. donwb "Patrick Molloy" wrote in message ... Mark got the right answer, when showing the second form, set it to modal Private Sub CommandButton1_Click() UserForm2.Show vbModal End Sub "donwb" wrote: Excel 2003 Win XP I have a large (physically) userform one control of which calls another (smaller) UF. Sometimes the smaller form, when called, appears on top of the larger one which is the required result. However sometimes it is beneath or hidden by the larger one which is not the required result. If I minimise the larger form, move the smaller one to where part of it is visible when the larger one is maximised again, then click the smaller form itself, (not a control) then all the form is on top of the larger one. I have tried repaint to no avail. How can I ensure the smaller form, when called, always appears on top of the larger one. Could I click the smaller form programmatically. donwb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform moves when hidden and shown again. | Excel Programming | |||
Userform data entry into hidden sheets | Excel Programming | |||
How to evoke a hidden userform? | Excel Programming | |||
differentiate between a visible and a hidden userform | Excel Programming | |||
Use userform to get input and compare to a hidden sheet | Excel Discussion (Misc queries) |