take user clik as an input

  • Thread starter Thread starter Yossi evenzur
  • Start date Start date
Y

Yossi evenzur

Hi
I'd like to run a macro in a new sheet is inserted and the user is asked to
name a new sheet, how can it be done?
 
Sub askfornameofsheettoinsert()
myname = InputBox("Enter name of new sheet to insert")
Sheets.Add
ActiveSheet.Name = myname
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collect User Input 2
"Web" Command Bar always appears on start up 2
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Macro that unhides a sheet and takes the user to that sheet 2
Macro to copy value in field and insert it into filter 2
Forgot Username Feature 0
How to use comma separated inputs in macro 4
Create a new worksheet based on and input box 3

Back
Top