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

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