Results 1 to 20 of 20

Thread: Sleeper: Userform transfer variables?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Aug 2005
    Posts
    56
    Location

    Sleeper: Userform transfer variables?

    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.
    Last edited by Aussiebear; 03-31-2023 at 06:29 AM. Reason: Adjusted the code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •