Re: $$Excel-Macros$$ Switching between windows when a form is opened

2011-09-16 Thread rajan verma
Hi use this when showing your user form : userform1.show 0 user form will show modelless andit allow user to interect with worksheet regards rajan On 17/09/2011, Sam Mathai Chacko wrote: > Mr Excellent, > > In the properties of the user form, you will have to change the showmodal > property to

Re: $$Excel-Macros$$ Switching between windows when a form is opened

2011-09-16 Thread Sam Mathai Chacko
Mr Excellent, In the properties of the user form, you will have to change the showmodal property to False Regards, Sam Mathai Chacko (GL) On Fri, Sep 16, 2011 at 2:57 PM, Mr Excellent wrote: > *DID YOU GET MY QUESTION AS THE ANSWER IS NOT RELEVANT* > > > On Fri, Sep 16, 2011 at 1:07 PM, Anas A

Re: $$Excel-Macros$$ Switching between windows when a form is opened

2011-09-16 Thread Mr Excellent
*DID YOU GET MY QUESTION AS THE ANSWER IS NOT RELEVANT* On Fri, Sep 16, 2011 at 1:07 PM, Anas Alam Habibullah wrote: > *Try > Ctrl + PageDown > > or > > Ctrl + PageUp > * > > On Fri, Sep 16, 2011 at 9:28 AM, Mr Excellent wrote: > >> Hi Group, >> >> This might be a unique question to ask, but need

Re: $$Excel-Macros$$ Switching between windows when a form is opened

2011-09-16 Thread Anas Alam Habibullah
*Try Ctrl + PageDown or Ctrl + PageUp * On Fri, Sep 16, 2011 at 9:28 AM, Mr Excellent wrote: > Hi Group, > > This might be a unique question to ask, but need to when the form is active > on my screen and i want switch between form and other excel sheet , but it > is not happening is there any po

$$Excel-Macros$$ Switching between windows when a form is opened

2011-09-16 Thread Mr Excellent
Hi Group, This might be a unique question to ask, but need to when the form is active on my screen and i want switch between form and other excel sheet , but it is not happening is there any possibility that when the form is opened and can switch between the windows, usally the need of swtching bt