Using a cell reference to open a specific sheet within a closed workbook

Hi All!

I haven't played with VBA for quite a while now, so please excuse me if I am a little rusty!

What I would like to do is to open a named workbook and specific sheet with text from a cell reference.

I have two sets of radio buttons which give various text results when checked.

For ease of explanation set one returns small, medium and large whilst the second set returns red, green and blue

I have three workbooks (small, medium and large) each with three sheets (red, green and blue)

I would like to open one of three workbooks based on the output of the first set of buttons, i.e. small.xlsx, medium.xlsx or large.xlsx
and one of three sheets based on the output of the second set of buttons

I have used this piece of code to open the workbooks:

Please Login or Register  to view this content.

This works fine, but I haven't been able to open a specific sheet within the workbook.

Any ideas?

Thank you for your help

Wiggy

Hi Nathan,

Thank you for your reply,

The call for the worksheet also needs to be derived from a cell reference, I have tried playing around with your suggestion, but with no success as of yet!

Hi Nathan,

Thank you for your reply,

The call for the worksheet also needs to be derived from a cell reference, I have tried playing around with your suggestion, but with no success as of yet!

Hi All,

I am still trying to play with this problem,


I have tried a couple of different options, but still can't get things working

The latest code I have is:

Please Login or Register  to view this content.

As with the first try I made, I can open the correct workbook based on the value in cell I18 but trying to open the specific worksheet based on the value of I16 is eluding me

Thanks for any help!