create worksheets

[julie_nickb]

Hello,

Just getting started in VBA.

- I would like to create new worksheets in VBA. The name of the worksheet is in a cell.
- Would like to verify that the sheet name is valid, send a message if it is not, and make the cell with the incorrect name active so that it could be corrected
- Would like to make sure that the sheet does not yet exist,

send a message if it does, and make the cell with the duplicate name active so that it could be either corrected or to cancel the sheet creation.

Thank you for your help.

Julie​

 

[silentwolf]

Hi
where do you like to store the name of the worksheet in one cell? What is a valid sheetname or what is not?
Have you worked with VBA before or are you completly new to VBA?

 

[julie_nickb]

Thanks for your response.
More simply, I would like to use data validation to determine whether the cell contains a valid worksheet name, and then create the worksheet.