VBA overflow error Double/Long

[epactheactor]

Hello!

I'm writing a macro and I keep getting an overflow error. At first I believed it was because I was using Integer and the value was too large for that data type. But I've tried Long and Double to the same error. What am I missing?

Values being used;
material = 35000
txtWT = .5
txtDia = 8.625

This is the formula;

answer = (material/(txtWT * 2)) / txtDia

I split it up to see if maybe that was the problem to this;

X = txtWT * 2
Y = material / X
answer = Y / txtDia

Thank you for any help.

 

[epactheactor]

Hi shg,

I just figured that out a second before.

Thank you everyone for your help. I was under the impression that you could have the variable be the same at the text box that the data is entered into. I see now this was the issue.

Again, thank you everyone for your help.

 

[shg]

You're welcome.