Hi,
I am quite new to
VB and suspect my problem is due to lack of knowing the
fundamentals of structuring procedures etc.
My macro brings up a user form at the beginning which includes a text box.
The macro then goes through quite a lot of code and towards the end I want to
refer to the value of the text box. I have tried referring to it as :
€śUserForm1.Textbox1.value€ť to use the value in a calculation but I get the
error :
Run-time error 13 Type Mismatch
Do I have to add any code within Private Sub TextBox1_Change() ? or declare
a variable somewhere in my macro ?
Thanks in advance for any help anyone can provide.
Regards
Pete