I'm sure this must be incredibly simple, and i've tried using the search function but to no avail!
Basically, is it possible to make a selection from a combo box (values taken from a table on another worksheet) and have this link to a pre-selected worksheet in the same workbook?
So on sheet 1, we have a combo box using the values from A1:A3 on sheet2.
These are
Sheet3
Sheet4
Sheet5
When user selects option 'Sheet3' from combo box, they are linked to Cell A1 of sheet3.
I'm sure it must be simple, but i've got an inability to do anything productive all day today.
Basically, is it possible to make a selection from a combo box (values taken from a table on another worksheet) and have this link to a pre-selected worksheet in the same workbook?
So on sheet 1, we have a combo box using the values from A1:A3 on sheet2.
These are
Sheet3
Sheet4
Sheet5
When user selects option 'Sheet3' from combo box, they are linked to Cell A1 of sheet3.
I'm sure it must be simple, but i've got an inability to do anything productive all day today.
