trasfer data into a userform

**vin1** · 03-21-2011, 06:20 AM

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?

**royUK** · 03-21-2011, 06:28 AM

To use the variables from another macro they need to be declared as Public.

Can you attach an example workbook, there's probably a simpler way to do this

**vin1** · 03-21-2011, 07:53 AM

The excel is dutch based so i used dutch names.

I only used "Rekening" as excample that will be filled in the userform.

The idea of the userform is to double click the line that needs to be changed and with the userform you will change its data.
this way the user cannot destroy the database field.

When i change dim statement with public it gives an error.