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