Use a variable value from a different function

[craig1988]

Hi

I have got myself into a muddle

I want to set a variable within a function. The variable is strOutput and is a string. I have this tested and it works fine.

I have an onClick event that I want to use the variable above in. I am so confused??? The onClick Code goes as below...

Public Sub btnRequest_Click()  
    MsgBox strOutput, vbInformation, "Test"
End Sub

Obviously this is not all the above sub does but its just an idea of what I need to do.

Have I got myself mixed up between public/private function/sub?


I think I have to declare the variable in the second sub but I dont know how??

Regards

[pbaldy]

Either the function should return the string:

MsgBox FunctionName(), vbInformation, "Test"

Or the variable would have to be declared as public in a standard module

Public strOutput As String