I need to add validation to all my textboxes in my userform. Th
userform has textboxes connected to a worksheet (using controlsource
on which I create some graphs. I'll be looking at validating correc
ranges, positive numbers, string lengths and so on.

I've been looking at a couple of solutions. Range.validation.add an
the BeforeUpdate event, but none seem to work as I want.

I've also found something called Micorsoft Masked Edit Control, but i
seems my licence doesn't include it.

How can I catch invalid input before it generates errors in my code? A
it it now, users can input values that create division by zero and s
on.

Thanks in advance!

On a side note: If a number is entered that creates a division by 0
the formula in my cell gets deleted. Why is that

--
Message posted from http://www.ExcelForum.com