Using a value from one subroutine in another.

[rmar2011]

Hello, I am designing my first UserForm structure in VBA (having had programming experience in school) for my internship. One thing I was wondering was how to push the value of a variable from one subroutine (say a text box in this case) to another subroutine.

Please Login or Register  to view this content.

Then once I get that BlockNumber moved to the second subroutine on the form (this one is a okay button) i was wondering if there was anyway to use that value (BlockNumber) in a directory to open a file? So replace that "9043" in the directory with a form of BlockNumber that is specified by the user.

Please Login or Register  to view this content.

if this is too confusing I can try to explain clearer, thanks a lot!

[romperstomper]

Since you have the textbox available to both routines, the first one serves little purpose really (you would have to declare Blocknumber outside that routine for it to retain its value after the routine finished). Try just:

Please Login or Register  to view this content.

[rmar2011]

That worked great! Thanks a lot, I figured I was being repetitive with those subroutines but since this has been my first two days working with VBA I wasn't sure.

[romperstomper]

Glad to help. (boilerplate request follows...)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save