Check if sheet name already exist

[Tpleme]

Hello, i have this segment of the code that creates a sheet named with the textbox1.value.

I want it to check first if that sheet already exists, if so dont create the sheet and continue the code.

Please Login or Register  to view this content.

hope u can help me

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[Tpleme]

thank you, works like a charm, bu t i still dont get that part.

can you explain that section?

Please Login or Register  to view this content.

i realy like to understand the code and what it does insted of just copyu paste :D

[YasserKhalil]

You're welcome
ISREF is a worksheet function which can be used in worksheet

Please Login or Register  to view this content.

It returns True if Sheet1 exists .. and if you change "Sheet1" to non-existing sheet, a window of "Update Values" will popup as an evidence that the sheet is not existing so this returns True or False
And using Not reverse the boolean value ..
so if the sheet doesn't exist so this part would return 'False' and Not False =True then the lines after the condition line will be executed
Regards

[Tpleme]

got it :D

thanks for your help

Best Regards

[YasserKhalil]

You're welcome. Glad I can offer some help
please mark the thread as solved