samedi 28 mars 2015

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

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?


Aucun commentaire:

Enregistrer un commentaire