Hi guys, I have been trying to get a userform to work for a long tim
now with no luck, so I thought its time to ask.

I have made a custom userform that has three textbox and a submi
button.
I want the user to be able to type in three values in the boxes and us
the submit button to store the user input in three different define
variables.
Does anyone have the time to help on this

--
jnasr0
-----------------------------------------------------------------------
jnasr00's Profile: http://www.excelforum.com/member.php...fo&userid=2851
View this thread: http://www.excelforum.com/showthread.php?threadid=48303

Hello jnasr00,

The code for the Submit button will be placed in the Click_Event() by
default. So the code would look something like this...

Code:
--------------------

Sub Submit Click_Event()

Dim Var1 'Variable 1
Dim Var2 'Variable 2
Dim Var3 'Variable 3

Var1 = TextBox1.Text
Var2 = TextBox2.Text
Var3 = TextBox3.Text

End Sub

--------------------

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=483037