I have a problem with obaining the data into the userform.

There is 1 macro and 1 userform.

The marco's event is when a specific cell is double clicked in a screen.

In this macro there will be data gathered and stored in variable's.

the next step is that the macro opens the userform and the gathered data should be added into the userform.


i have tried adding the information by macro which doesnt work ofcourse.
Then i tried it by using the "Userform_initialize" event.

This works but i cannot collect the data from the macro variable's.

Anyone can tell me how to declare these variables so they are comminucating?