userform variable

**mena** · 06-04-2018, 11:18 AM

hi
how pass variable from userform to another userform

thanks

**mjr veverka** · 06-04-2018, 11:23 AM

Quite simply, declare them in the standard module as global variables

**gmr4evr1** · 06-04-2018, 11:25 AM

You have to set the userform ShowModal property to False. Then, if the userform names are UserForm1 and Userfom2 like in the attached, use this for useform2

Please Login or Register  to view this content.

mena userform variable.xlsm

**Greg M** · 06-04-2018, 11:32 AM

Hi there,

Good programming practice indicates that values should be passed to UserForms, Classes etc. by means of user-defined properties of those objects.

I can give you more information on this approach if you need it.

Hope this helps.

Regards,

Greg M

**mena** · 06-04-2018, 11:50 AM

great thank you very much porucha vevrku

**mena** · 06-04-2018, 11:51 AM

yes i need Greg M ..... thank u

**Greg M** · 06-04-2018, 01:47 PM

Hi again,

See if the attached workbook gets you moving in the right direction.

Hope this helps - please let me know how you get on.

Regards,

Greg M