#### Westovski

##### New Member
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.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
*bump*

Replies
3
Views
476
Replies
0
Views
151
Replies
2
Views
378
Replies
12
Views
573
Replies
1
Views
333

1,203,534
Messages
6,055,955
Members
444,839
Latest member
laurajames

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back