DanOfEarth
03-28-2011, 08:11 AM
I'm trying to activate an existing worksheet via code based on the text content of a cell.
I've named the worksheets/tabs matching a list in an indexed cell attached to a drop-down-list-box (named "RecipeCatagory").
Indexed in that cell are: "Pork, Beef, Chicken, Seafood, Side_Dish, Dessert"
A silly example of what I'm trying to accomplish via code that obviously wouldn't work:
Dim RecipeCatagory As Long
RecipeCatagory = Range("Catagory").Text
Windows("RecipeList.xlsm").Activate
Sheets(RecipeCatagory).Activate
I'm stumped.
I've named the worksheets/tabs matching a list in an indexed cell attached to a drop-down-list-box (named "RecipeCatagory").
Indexed in that cell are: "Pork, Beef, Chicken, Seafood, Side_Dish, Dessert"
A silly example of what I'm trying to accomplish via code that obviously wouldn't work:
Dim RecipeCatagory As Long
RecipeCatagory = Range("Catagory").Text
Windows("RecipeList.xlsm").Activate
Sheets(RecipeCatagory).Activate
I'm stumped.