VBA Code to Add New Sheet and Rename - Excel VBA Example by ExcelDestination

VBA Code can be used on click event of Command to add new sheet. This example explains, how to use VBA Code to insert new sheet at the end and rename it.

[@doliwsef]

Hours I spend with renaming the new sheet, here it is! THanks!

[@peter-e2q]

Brilliant! Thank you. Now, I understand a bit more about ActiveX buttons too!!

[@makderm8166]

Thanks for the useful code. Is there any way to make excel use the date in that cell instead of a name ? It gives an error if the value of the cell is a date

[@royqi5264]

Great work, may I ask if this VBA code can be adjusted to add a new sheet based on the predesigned template ?

[@ExcelDestination]

yes it can be.

[@jashansekhon4414]

@@ExcelDestination Do you have a tutorial for that? I am looking for that.

[@cristianmorales3280]

What happens if you click the button twice, whats the vba code to avoid a bug error with a msgbox

[@randallboyacao3597]

amazing......you write another name on the b4 and click the button that will create another sheet then write another name on the b5 and click the button that will create another sheet then you write another name on the b6 and click the button that will create again another sheet(until you still want to add)??? i'm very thank full if you would provide as an example ...for our study thank youuuuuuuuu..

[@casst346]

you have to keep changing the name in B3, there is code to have a popup allow you to change name..in 2019 you have to use Worksheets to return back to the original Sheet1 not "Sheets"...

[@fridoniz.a3986]

for what?

[@MohAboAbdo]

Thanks ... Thanks ... Thanks ...