Object required when Calling a procedure from Useform?

Hi,

I have a problem, when i try to call a macro from userform, it gives me a macro error "Object Required".
Attached is the sample of what i am trying to do.

When you click on the rectangle, fill in any value and Submit, the macro won't recognise texbox1.value.

Can anyone help me?

Much Appreciated

Regards,
Lex

In the Fill_in_Texbox_Value() Sub, you have to tell excel which textbox you're talking about.

Please Login or Register  to view this content.

Hi lexusap,

You could have a TextBox1 on a lot of userforms so you need to use this line...

Range("A" & EOR1 + 1).Value = UserForm1.TextBox1.Value