Change Sheet tab from multiple Cell Values (Help FIX)

**goatie43** · 03-08-2015, 11:00 AM

Hey Guys again i have a macro that changes worksheets (tabs) based on cell value. I have it working correct for one cell (B2) but i need 3 cells (B2, F2, M2) that i can type the sheet name in on the first sheet and it directs to the sheet could someone explain how i would add those cells to my code? Thanks for all the help.

MODULE:

Please Login or Register  to view this content.

Sheet Code:

Please Login or Register  to view this content.

**stnkynts** · 03-08-2015, 12:07 PM

Please Login or Register  to view this content.

**Norie** · 03-08-2015, 12:13 PM

Perhaps.

Please Login or Register  to view this content.

**goatie43** · 03-08-2015, 12:29 PM

Thanks Guys ill give these a try.

**goatie43** · 03-08-2015, 12:37 PM

Thanks Guys they both worked perfectly.

**goatie43** · 03-09-2015, 07:43 AM

Hi again i just realized today that i still have an issue, I have 2 two cells i can type a sheet name into G10 and H10, But if i have sheet4 written in G10 and a type a new name into H10 it say sheet6 it will still go to sheet4 here is my code again for my Module and Sheet.

Module

Please Login or Register  to view this content.

Sheet

Please Login or Register  to view this content.

Thanks

**stnkynts** · 03-09-2015, 09:30 AM

Sheet1.Range("G10") and Sheets("Sheet1").Range("G10") are completely different and could be 2 entirely different sheets/ranges. Research sheet index number for some more clarification.

**Norie** · 03-09-2015, 09:35 AM

Also, where do Sheet4 and Sheet come into it?

**goatie43** · 03-09-2015, 09:44 AM

Okay here is an example i have two drop downs, One drop down contains sheets 1 through 5 and the second drop down contains sheets 6-10. Just think of it as the first drop down only shows Fruits and the second only shows Veggies. Ive been watching a few videos i knew nothing about macros till a week ago and just learning. I uploaded an example sheet, But thanks for the help

Workbook2.xls