Obtaining variables during a userform_initialize event

  • Thread starter Thread starter jbugara
  • Start date Start date
J

jbugara

I am using the worksheet_beforedoubleclick event to open a userform.
During the userform_initialize event I need to obtain value of the
'target' arguement that is referenced in the
worksheet_beforedoubleclick event. How can I obtain this value? Do I
need to go with a public variable?
 
It depends on how and where you are going to use the variable populated
with the target.value
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autoload UserForm TextBoxes 4
Disable all Control Events on a Userform when it is Intialized 1
Event Macro - propogate formula 3
Worksheet_BeforeDoubleClick Stops Working 3
Passing data to an event handler 3
Do not execute Double Click Event when UserForm is Showing 4
How to populate Label1.Caption with a variable's value 3
Create a public variable 4

Back
Top