Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pass values from a userform to a standard module?
Excel 2000
Windows 2k Pro I need to know how I can pass values from a userform to a standard module and vice versa. I have a Workbook that has a custom menu from which the user can choose a "Run Setup" option. Choosing this loads and shows a userform. One of the controls on the userform calls a "Get_Path_and_Filename" subroutine that is in a standard module. I'd like to return the path and file name string from the standard module to a text box on the userform. Should I move this subroutine to the userform module? Perhaps it's a matter of where I declare variables? Kinda scratching my head on this one, any suggestions appreciated. -gk- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to standard module | Excel Discussion (Misc queries) | |||
Renaming a standard module | Excel Programming | |||
How to pass arguments from ThisWorkbook to a UserForm | Excel Programming | |||
Pass a variable from a class module | Excel Programming | |||
Delete userform/module using VB | Excel Programming |