I have the below code but incapable of figuring out how to write it in vba and if its the right way to approach it:
I am trying to check if cell range 'customer' has value if not then messagebox 'please fill in name' , then proceed to check cell range 'desinger' has value, if not then messagebox 'please choose designer'
Please Login or Register to view this content.
if both cell has valuen, then proceed. when i run that code its says 'compile error 'NEXT WITHOUT FOR'
Hi chubbychub,
If I have understood the request, the following For-Next loops must be modified as shown
Please Login or Register to view this content.Try it and let us knowPlease Login or Register to view this content.
Bye
Max
let's compare ideas
it says compile error, 'else without if'
Hi chubbychub,
the code below is correct and does not report any errors, but I have made two lines of code comment because I do not know which libraries to associate them with or whether they are user-defined types
Try again and let me know.Please Login or Register to view this content.
Bye
Last edited by maxpit; 10-02-2023 at 05:10 PM.
got it, that worked! thank you maxpit!
Hi chubbychub,
you are welcome and thanks for rep.
Bye
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks