Copy sheet with popup message asking to name the new copied sheet

polska2180

Active Member
Joined
Oct 1, 2004
Messages
345
After testing my last script I find it will not work.

I really have no answer for you.

Your wanting if the user enters a improper name or no value or clicks Cancel button to get no warning but just try again. If I were a user I would wonder why is this script just running over and over. I'm not sure what I'm doing wrong.
Pretty standard process when using any PC, cancel...script ends you don't get warnings. You try to save something w/o a name it doesn't give you script errors and sends windows into debug mode just wont let you save.

I appreciate your quick help, it got me 95% there and for now it will be good enough unless somebody else chimes in.
 
Last edited:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,278
You said:
Pretty standard process when using any PC, cancel...script ends you don't get warnings.

OK if I'm trying to do something and script just ends after doing nothing how do I know what I did wrong?


 

polska2180

Active Member
Joined
Oct 1, 2004
Messages
345
You said:
Pretty standard process when using any PC, cancel...script ends you don't get warnings.

OK if I'm trying to do something and script just ends after doing nothing how do I know what I did wrong?


Cancel means I changed my mind and I don't want to proceed.
 
Last edited:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,278
Well I can get the cancel thing to work.

But your saying if the users performs any error you never want to see a Message Popup telling him he made a error.

You just want the Inputbox to pop back up.

But as far as I know there is no way to do that.

Like for example if the use Enters Jane/Doe into the Inputbox Excel says to itself this is not a Proper Name because I do not allow a / in a sheet name.

And the script should end then.

But you have said you never want to see a Message about a Error and you do not want to press the Button that starts the script again. You just want the Input Box to pop back up so you can enter a new name.

And if the user enters Jane/Doe a second time Excel again says that name cannot be used and errors out again.
 

Forum statistics

Threads
1,082,017
Messages
5,362,695
Members
400,686
Latest member
Aakash

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top