VBA Sheet selection based on Cell Value/Text

[exceknk]

Need Help-

I have a excel workbook with 9 sheets. First sheet is named "Master" while others are named from P001 to P008. On Master sheet, I have marked cell E7 as input.

I want VBA code to select the specific sheet which is inputted in Cell E7 of "Master" sheet.
Example- If "E7" cell has value of "P004", then my VBA code should select sheet named "P004".

I am new to vba. Please help.

Thanks.

 

[Osvaldo Palmeiro]

Hi.
Try:

Sub ActivateSheet()
 Sheets(Range("E7").Value).Activate
End Sub

 

[exceknk]

Thanks. It works.