Hi I have a user form that opens when the workbook is opened. In this user
form I have text fields in which the user shall submitt info. How do I get my
macro to "read" the text submitted into the text field after a button on the
user form is pressed?

You do that by reading the text or caption property of the objects on the
userform. The specific code depends on your setup, but in general something
like this in the commandbutton click event, with myVar1,2 &3 being declared
public variables...

myVar1 = Userfrom1.Textbox1.Text
myVar2 = Userfrom1.Textbox2.Text
myVar3 = Userfrom1.Textbox3.Text

HTH,
Bernie
MS Excel MVP

"april27" wrote in message
...
Hi I have a user form that opens when the workbook is opened. In this user
form I have text fields in which the user shall submitt info. How do I get
my
macro to "read" the text submitted into the text field after a button on
the
user form is pressed?

Just access the value of the control:

msgbox Userform1.Textbox1.Value



--
Regards,
Tom Ogilvy


"april27" wrote:

Hi I have a user form that opens when the workbook is opened. In this user
form I have text fields in which the user shall submitt info. How do I get my
macro to "read" the text submitted into the text field after a button on the
user form is pressed?