hey ppl,
this seems like a silly qestion to me but i cant find out what the problem is....
i open up a userform through a macro. when all the information is entered and submit is hit, i want all the info in the text boxes to be transfered to variables that the rest of the macro can use and manipulate...
how do ya do that?
i have this in the code of the submit button, it doesnt work:
If (txtstate = "") Then
MsgBox "You didn't enter a state, Try Again."
Exit Sub
End If
state = txtstate.Text
the if statement is cool, but the variable transfer isn't.
thnx fer any help.