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