UserForm Value

[Guest]

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

 

[Bob Phillips]

Pete,

It sounds as though you are trying to load a string (the textbox value) into
an integer or long variable.

Try CInt(Userform1.Textbox1.Value)