Tranferring Variable Entry from Form Entry to Macro

[austindude]

I used a form with textboxes for data input for one of my vb macros. Currently I have the private sub from the form transfer those entries to a remote cell on the spreadsheet, (like in column "HZ"), so that the macro that will actually utilize them can retrieve them. Is there a way to pass that data directly from what is entered in the form in the textboxes to the macro that will actually use them? Thanks

[shg]

A macro can read the value of a textbox directly:

someString = userform1.textbox1.value

[karan]

Hi Austin,

You can use the code given by Shg till the time the Userform has not been unloaded. Once you unload the userform, the value is lost. However, you can store them in a global variable which you have to initialize in a module as:

Please Login or Register  to view this content.

and then before unloading the userform, write the code:

Please Login or Register  to view this content.

followed by your macro which can use the value of xyz.

Regards,
Karan

[austindude]

Thanks for Replying. It was extremely helpful.

[shg]

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes