John,
Thanks for the quick response. First off, with some slight modification as you will see below to bring your code down to my level of VBA understanding, i have a working example that for my purposes will work fine. So thank you for pointing me in the right direction...
I need a little more clarification on the code.
I took the code above and copied it into each sheet that I want to be able to switch too. I made the basic modifications so that it would match the worksheets and it didn't work. So I simplified it to its basic function as follows:
The error I am getting is in reference to each line of code
I'm not really sure what that line of code is supposed to do since I do not have any textboxes on the sheet.
I'm also not sure what the code below is going to do either and was hoping you could explain that too.
I'm assuming that the above code is looking to reference the same list as Combobox1 but I want to make sure i understand it.
I am attaching a test workbook just in case.
Bookmarks