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?