VBA code should ask for every sheet to rename

[keshavtale]

in the attached file there is VBA code that code i use to raname sheets name but that code only rename one sheet at a time, then i should run again
that macro to rename another sheet , i want that VBA ask for every sheet until whole sheet not renamed in this file there is four sheet
so VBA should ask me four time to rename the sheet

[nankw83]

Hi keshavtale,

Try below code, just ensure that you have the same order of names & count in each array

Please Login or Register  to view this content.

[keshavtale]

i want to show inputbox for which sheet you want to rename , if there is four sheet in that workbook then ask four time it means show inputbox four time

[nankw83]

Ok, try this ...

Please Login or Register  to view this content.

[keshavtale]

ok this is fine , i want just like that , thanks now my problem is solved

[6StringJazzer]

You need to move the prompt into the loop. Also since you are doing this for every sheet you no longer have to ask them for which sheet to rename. You also have to account for blank input, or if the user hits Cancel.

Please Login or Register  to view this content.

[keshavtale]

thanks Mr. 6StringJazzer you give me perfect code

[nankw83]

@keshavtale to make the code more robust & account for user error/invalid data entry as highlighted by 6StringJazzer, I have added more validations to the code ...

Please Login or Register  to view this content.