How to Pass Textbox Name from module to module? VBA EXCEL

Question

Im trying to pass a textbox name from one module to another and then assign a value to that textbox.

Here's what I was trying.

Sub MyTest(txt as Textbox)
txt.value = 1
end sub

sub Try()
MyTest userform1.textbox1
end sub

Can someone point me in the correct direction?

MickeyCodes · Accepted Answer · 2015-03-28 22:50:44Z

1

All I needed to do was change (txt as textbox) to (txt as control) Thank you.

Sub MyTest(txt as Control)
txt.value = 1
end sub

sub Try()
MyTest userform1.textbox1
end sub

answered Mar 28, 2015 at 22:50

MickeyCodes

431 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

You should also be able to do it as As MSForms.TextBox