UserForms
Hi Son iya,
Create a public variable in the userform and set that before showing
indicating where activated from.
Userform2.pCaller = "Proc myMacro"
Userform2.Show
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"soniya" wrote in message
...
Hi All,
I have userform1 and userform2
normally userform2 is activated by clicking
commandbutton1 in userform1 and when userform2 closed
userform1 is activated againd.
now if i want to activate useform2 independadly how i can
identify whether it was called from userform1 or not. so
if it is not activated from userform1 then when i close
userform2 it will not show userform1
TIA
Soniya
|