Insert and name new sheet using UserForm

Hello

I'm using a UserForm to gather information.

Two new sheet will be created and named using a field gathered from the UserForm. Ranges will be created using part of the name.

I tried the following to name the new sheet yet receive a Run-time error; any suggestions? If possible, could someone explain the principle for using the ReportName as a variable as I need to use it naming ranges on the sheets.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

I have to declare it as a variable! Makes sense I guess.

So where the TextBox value if captured in "ReportName" I simply change change to "sReportName = Me.ReportName.Value"

And if I need to append the sheet name, it would be "sReportName"&"Temp"?

Thanks royUK.

I tried your suggested code and received a run-time error; 1004 object undefined. VBA doesn't seem to like "ActiveSheet.Name = sReportName" - any suggestions?