Hi, as far as I know is that if you're using complicated formulas with IF and OR statements or more and you want the user to enter data themselves, the I suggest you create a userform with all the fields that require data and carry out all the verifications in the VBA code before populating the formula.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I think if we had such tool it would be very helpful for complicated algebraic expressions just with mathematical operator precedence. The other excel functions like IF, OR, VLOOKUP and . . . can be ignored simply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks