VBA Textbox Calculations

Hi,

Is there anyway i can adapt the following code to work in the last textbox(6).

Basically its an adaptation of an excel formula which i wanted to enter into a Userform

What i have is as follows, i'm just not sure how to syntax it correctly and where to add it in the TextBox6 code

Many Thanks

Please Login or Register  to view this content.

Zhb,

Set up a variable for each textbox item, then simply add them to the formula. For example:

Please Login or Register  to view this content.

Obviously, my example is a made up formula and I didn't create variables for ALL of your textboxes, but I think you can figure it out from there.

As far as WHERE to add it, this really is up to you and based on need. For example, it may not even be in the TextBox6 code. Instead, it might be in the TextBox5_Exit (meaning as soon as you exit TextBox5, the code runs. It's hard to answer this part of your question without seeing your userform, and explaining what you need it to do.

Brilliant, thanks both of you