Linking selections in combo boxes.

[liam_conor]

How do I link the selection that I have made in my combo box to other worksheets?

 

[Andrew Poulsom]

What is in your combo box and what do you mean by "link the selection to other worksheets"?

 

[liam_conor]

The names of multiple worksheets with in my workbook are in this combo box (drop down list box). I want to be able to select a worksheet name and then be taken to that specific worksheet.

 

[Andrew Poulsom]

See:

http://216.92.17.166/board/viewtopic.php?topic=24753&forum=2

 

[liam_conor]

Thank you for the reference. However, my combo box in embedded in the worksheet and I do not clearly understand the correlation between what Mr. Evans did and what I am trying to do. How do I control the selection value, such as the output 1, 2, 3, ect., from the combo box to return a worksheet with in the workbook?

 

[Andrew Poulsom]

Assuming your combobox contains a list of worksheet names and is named ComboBox1:

Private Sub ComboBox1_Change()
    Sheets(ComboBox1.Value).Activate
End Sub

 

[liam_conor]

Thank you. Don't know how I missed that in the reference.