Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Public to Pass Variable
I have a UserForm that captures the users name, I am trying to pass that
information to another UserForm. I'm assuming that is possible using the Public declarations, but I am obviously having problems. Here is my example code Public Name As String ________________________________ Private Sub OKButton_Click() Name = NameBox1 UserForm4.Hide End Sub ________________________________ 'Name gets passed to this UserForm ________________________________ Private Sub SignOffButton_Click() MsgBox Name Unload UserForm5 End Sub ________________________________ Do I need to declare the variables Public in UserForm5 also? Are they declared in the right place? Should the subs be name Public instead of Private? etc. My MsgBox is returning empty. Any help is greatly appreciated. DP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Public variable | New Users to Excel | |||
Public variable usage! | Excel Programming | |||
Public Variable | Excel Programming | |||
Public/Procedure Variable | Excel Programming | |||
public variable | Excel Programming |