I hope someone will solve these problems for me. I'm using Excel in Office 365.
In the userform I have some codes and a few of them need some conditions to display the results.
However, when I used multiple Ifs and Else in the coding, something went wrong. It seems that the code will run according to which comes first.
It is very difficult to explain here so I've attached 2 files: Sample1 and Sample2.
Sample1 is the problematic one. I kept getting wrong message that does not 'match' the condition.
Sample2 has all the problematic codes "removed" (use apostrophes) to inactive them.
It runs smoothly, but I've no control over what should appear in the fields that have certain conditions.
Please run the 2 files and you can see what I meant.
Thank you very much in advance.
Bookmarks