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

[@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

[@doliwsef]

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

[@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.

[@peter-e2q]

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

[@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..

[@fridoniz.a3986]

for what?

[@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"...

[@MohAboAbdo]

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