If vbCancel = MsgBox(strInputErrorMessage & "Retry?", vbExclamation + vbOKCancel) Then GoTo HandleExit
If Len(strInput) = 0 Then GoTo HandleExit ProjAddress = ActiveSheet.Range("C7").Value
Change sheet name in excel for mac code#
Here's the code for the actual macro (affected area is: Sheets("TEMPLATE").Copy After:=Sheets("TEMPLATE")) '=Ĭonst cstrTitle As String = "Create a new GSA worksheet"Ĭonst cstrPrompt As String = "Enter the GSA number for the new worksheet"ĭim strInput As Variant 'Input value from user (GSA Number)ĭim strDefault As String: strDefault = "" 'Sets default value for inputboxĭim strInputErrorMessage As String 'Error messageĭim booValidateOK As Boolean: booValidateOK = False The actual "Sheet already exists" works, however, before prompting me with this error it duplicates the TEMPLATE worksheet for some reason. I'm currently running a macro that copies a template sheet, takes user's inputs, renames the sheet, and places the user inputs in the sheet.Įverything seems to be working except for the function that checks if the Sheet name already exists.
0 kommentar(er)
