I'm trying to figure out where I am going wrong with my macro. the macro is tied to textbox change events for WTextBox7 & 9, but every time I type something in one of the textboxes i get a divide by zero error it should just do nothing if one of the cells is blank or has something written in it. any help would be appreciated.
Thanks,
Chris
Please Login or Register to view this content.
Last edited by Code Flunkie; 05-27-2014 at 11:16 AM.
Assuming that the code is in your userform module:
you need to place the not before every part of the if statement if you want it how you have written it, i.e. if not x = y and not a = b and not etcPlease Login or Register to view this content.
Also, you need to use a . to reference the with statement.
FWIW, you might get away with:
Please Login or Register to view this content.
Does this work any better?
Please Login or Register to view this content.
If posting code please use code tags, see here.
works great, thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks