Public Variable between Sub and Userform

[BrianAll]

Hello,

I need to pass a variable and its value from the Sub where it is declared to a Userform.
How can I do it? Here a simple example.

Sub

Please Login or Register  to view this content.

Userform

Please Login or Register  to view this content.

Thanks in advance
Regards

[TMS]

Like this:

Please Login or Register  to view this content.

[Kaper]

Please Login or Register  to view this content.

If you want Red (public) Isplit to hold value of cell in row Rsplit, column C, then you cannot declare local variable (blue) with the samme name.

Try:

Please Login or Register  to view this content.

[BrianAll]

It works, thank you both.
How about doing it the other way round? I mean passing a variable from the Userform to the Sub.
Something like:

Please Login or Register  to view this content.

The problem is that when I go back to the Sub the Private Sub CommandButton1_Click() is terminated so the a value of "a" in Sub is empty.
(I didnět declare "a" in the Sub).

Thanks again

[Kaper]

declare:

Please Login or Register  to view this content.

in standard module (where you declared ISplit) , not in userform code

[BrianAll]

Works fine with: [seems there is no need of Public declarations for bringing a variable from userform to Sub, right?]:
Sub (No Public declarations)

Please Login or Register  to view this content.

Userform

Please Login or Register  to view this content.

Works fine with:
Sub

Please Login or Register  to view this content.

Userform

Please Login or Register  to view this content.

Not working with (equal to previous exchanging a with FSplit): [Error - Found non univocal name: FSplit]
Sub

Please Login or Register  to view this content.

Userform

Please Login or Register  to view this content.

[Could you tell me the differences between the three methods?]

Thanks!

[Kaper]

Brian,

Please DO observe Rule 3 of https://www.excelforum.com/forum-rul...rum-rules.html

Moreover, It's usually easier to respond if sample file is attached, not code alone.

[BrianAll]

Sorry, Kaper. I did it but I probably published an older version of the reply (made something messy with the preview).
I've modified the reply with the code tags.
Thanks again

[xlnitwit]

Your first code will not work without a public declaration. The fact that your third code produces the error it does suggests that you do have FSplit declared as a Public variable somewhere else already.

[BrianAll]

Hi xlniwit, it really helped.
Regards

[TMS]

You're welcome.



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


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

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


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[BrianAll]

Finally a quicker method to mark it as solved...
I was already trying to figure out how the old one works...
Thanks