Problem with division

[bralew]

Hi I cannot get this part of code to work?

Basically, TextBox4 divided by textBox2

Please Login or Register  to view this content.

[mikerickson]

"Doesn't work" is a bit vague.

What happens (or doesn't) that you don't (or do) want to happen? And under what conditions does this happen or not?

BTW, are these text boxes on a user form or are they ActiveX on a worksheet?

[bralew]

Sorry, On a userForm - Run time error 11

[xlnitwit]

That means that Val(TextBox2.Value) is returning 0.

[bralew]

My brackets are wrong? Lol

[xlnitwit]

Presumably whatever is in there is not a number. Is it blank?

[bralew]

Sorry People just lost some work, I'll have to get back to you in the morning, thanks for help

[nilem]

maybe

Please Login or Register  to view this content.

[bralew]

I've got it now lads, however, my last calc is not performing when I press the command button2.

Rather than have another ComboBox, I'm asking the exiting contents of TextBox5 (which is 8) to be divided by one?? Can it be done chaps?

Please Login or Register  to view this content.

[xlnitwit]

What is the point in dividing by one?

[bralew]

Shite, I've just realised I need 1 divided by 8 Lol, Sorry Man

[bralew]

Sorry xlnitwit, its been a long day Lol. I needed 1 divided by the TextBox contents. All sorted now, thanks