From: Chris W on 13 Apr 2010 08:30 Hi All Having searched around, I have not yet found an answer to my problem, so hopefully one of you experts out there will know the answer. I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at document launch. On my main multipage when I select the relevent tab, I show the F2 in modal and work there. When the user selects a tab on F2 which means transfering control back to F1, I Hide F2 and control is passed to F1 where I process the code for the relevent tab. What is happening is that the tab is selected, BUT there are no controls at all shown on the page. If I navigate away from the selected tab to another, and back all is shown again. Is there a way of doing this navigation so that the tab's controls are shown in the first pass rather than mocing off the tab? Many Thanks Chris
From: Fumei2 via OfficeKB.com on 13 Apr 2010 12:41 I am not following this. It sounds like when you selct a tab on F2, control is passed to F1. If this is correct, why does it matter that controls on F2 are visible or not, since you are not even there? I am missing something. Gerry Chris W wrote: >Hi All > >Having searched around, I have not yet found an answer to my problem, so >hopefully one of you experts out there will know the answer. > >I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at >document launch. > >On my main multipage when I select the relevent tab, I show the F2 in modal >and work there. > >When the user selects a tab on F2 which means transfering control back to >F1, I Hide F2 and control is passed to F1 where I process the code for the >relevent tab. > >What is happening is that the tab is selected, BUT there are no controls at >all shown on the page. If I navigate away from the selected tab to another, >and back all is shown again. > >Is there a way of doing this navigation so that the tab's controls are shown >in the first pass rather than mocing off the tab? > >Many Thanks > >Chris -- Gerry Message posted via http://www.officekb.com
From: Chris W on 14 Apr 2010 05:31 Hi Gerry Thanks for your reply. Basically I have too many controls to fit on one user form (I get the out of memory message), so I have split the main form into two, moving some pages of information onto the second form. I have designed the second form so that it looks exactly the same as the main form, in so much as it has a duplicate set of tabs - the difference being that for all the non-applicable tabs, there are no controls. This is overlayed onto the main form when required so that as the user navigates through the tabs as far as they are concerned they see no difference. The problem is, when I need to navigate back to the main form(i.e. the user has selected a tab on the second form where the controls reside on the main form), I hide the second form and the first is now showing, but without any controls visible until I navigate away from the selected tab -- Regards Chris "Fumei2 via OfficeKB.com" wrote: > I am not following this. It sounds like when you selct a tab on F2, control > is passed to F1. If this is correct, why does it matter that controls on F2 > are visible or not, since you are not even there? > > I am missing something. > > Gerry > > Chris W wrote: > >Hi All > > > >Having searched around, I have not yet found an answer to my problem, so > >hopefully one of you experts out there will know the answer. > > > >I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at > >document launch. > > > >On my main multipage when I select the relevent tab, I show the F2 in modal > >and work there. > > > >When the user selects a tab on F2 which means transfering control back to > >F1, I Hide F2 and control is passed to F1 where I process the code for the > >relevent tab. > > > >What is happening is that the tab is selected, BUT there are no controls at > >all shown on the page. If I navigate away from the selected tab to another, > >and back all is shown again. > > > >Is there a way of doing this navigation so that the tab's controls are shown > >in the first pass rather than mocing off the tab? > > > >Many Thanks > > > >Chris > > -- > Gerry > > Message posted via http://www.officekb.com > > . >
From: Chris W on 14 Apr 2010 05:54 Gerry Before you start digging around too much I found this post which covers my problem so I will investigate this further http://www.keyongtech.com/2267069-multipage-value-wont-change-page -- Regards Chris "Chris W" wrote: > Hi Gerry > > Thanks for your reply. > > Basically I have too many controls to fit on one user form (I get the out of > memory message), so I have split the main form into two, moving some pages of > information onto the second form. > > I have designed the second form so that it looks exactly the same as the > main form, in so much as it has a duplicate set of tabs - the difference > being that for all the non-applicable tabs, there are no controls. This is > overlayed onto the main form when required so that as the user navigates > through the tabs as far as they are concerned they see no difference. > > The problem is, when I need to navigate back to the main form(i.e. the user > has selected a tab on the second form where the controls reside on the main > form), I hide the second form and the first is now showing, but without any > controls visible until I navigate away from the selected tab > -- > Regards > Chris > > > "Fumei2 via OfficeKB.com" wrote: > > > I am not following this. It sounds like when you selct a tab on F2, control > > is passed to F1. If this is correct, why does it matter that controls on F2 > > are visible or not, since you are not even there? > > > > I am missing something. > > > > Gerry > > > > Chris W wrote: > > >Hi All > > > > > >Having searched around, I have not yet found an answer to my problem, so > > >hopefully one of you experts out there will know the answer. > > > > > >I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at > > >document launch. > > > > > >On my main multipage when I select the relevent tab, I show the F2 in modal > > >and work there. > > > > > >When the user selects a tab on F2 which means transfering control back to > > >F1, I Hide F2 and control is passed to F1 where I process the code for the > > >relevent tab. > > > > > >What is happening is that the tab is selected, BUT there are no controls at > > >all shown on the page. If I navigate away from the selected tab to another, > > >and back all is shown again. > > > > > >Is there a way of doing this navigation so that the tab's controls are shown > > >in the first pass rather than mocing off the tab? > > > > > >Many Thanks > > > > > >Chris > > > > -- > > Gerry > > > > Message posted via http://www.officekb.com > > > > . > >
|
Pages: 1 Prev: "Code Execution has been Interrupted" Next: Modifying SmartArt Text through Object Model |