$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement

2009-06-07 Thread Alokeshwar Tiwary
know. But there are also unknown unknowns. There are things we don't know we don't know." From: Ashish Jain <26may.1...@gmail.com> To: MS EXCEL AND VBA MACROS Sent: Sunday, 7 June, 2009 9:31:48 AM Subject: $$Excel-Macros$$ Re: UserFo

$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement

2009-06-07 Thread Alokeshwar Tiwary
know. But there are also unknown unknowns. There are things we don't know we don't know." From: Ashish Jain <26may.1...@gmail.com> To: MS EXCEL AND VBA MACROS Sent: Sunday, 7 June, 2009 9:31:48 AM Subject: $$Excel-Macros$$ Re: UserFo

$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement

2009-06-07 Thread Alokeshwar Tiwary
know. But there are also unknown unknowns. There are things we don't know we don't know." From: Ashish Jain <26may.1...@gmail.com> To: MS EXCEL AND VBA MACROS Sent: Sunday, 7 June, 2009 9:31:48 AM Subject: $$Excel-Macros$$ Re: UserFo

$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement

2009-06-06 Thread Ashish Jain
Hi Alokeshwar, This is absolutely normal. 1. When you try to fetch the values from userform1, it is initialized and new value of Test set upon. To avoid this you can use activate event of userform1. Difference between activate and initialize is of Foreground visibility active state and Backgroun