I have a simple Inputbox macro that creates a new sheet called whatever is unput. When hitting the cancel button though I get an error (object defined 1004 job)
How do I solve this?
Please Login or Register to view this content.
I have a simple Inputbox macro that creates a new sheet called whatever is unput. When hitting the cancel button though I get an error (object defined 1004 job)
How do I solve this?
Please Login or Register to view this content.
change so
Please Login or Register to view this content.
Last edited by patel45; 08-21-2012 at 10:50 AM.
Does the following do what you need?Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
works brilliantly thanks!
---------- Post added at 04:05 PM ---------- Previous post was at 04:03 PM ----------
also is there a way to force the input to be MMM YYYY if there is anything else it comes up with a message saying "Wrong input" or something>?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks