LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to standard module Simon Excel Discussion (Misc queries) 9 May 17th 07 08:25 PM
Renaming a standard module Todd Huttenstine[_2_] Excel Programming 5 December 31st 03 10:49 PM
How to pass arguments from ThisWorkbook to a UserForm strataguru[_4_] Excel Programming 1 October 7th 03 11:29 PM
Pass a variable from a class module pk Excel Programming 1 October 2nd 03 08:24 PM
Delete userform/module using VB Rohit Thomas Excel Programming 5 July 16th 03 11:01 PM


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"