Worksheet_BefordDoubleClick

[liampog]

Hi

I have a double click event that shows a Userform and I also have a button that does the same thing.

I want a piece of code when the Userform initialises that checks to see if the button or the double-click was used (to do different things).

I tried using If Application.Caller = "Button_Name" but when using double-click, this results in an error obviously.

Can anyone help me out?

Thanks in advance

 

[RoryA]

I would add a property/public variable to the form and assign it a value that allows you to tell which routine called it. Then use a public procedure (or the Activate event) instead of the Initialize event. If you're feeling lazy, just use a public variable.