Using a combo box to select a named worksheet

[mattster1010]

Good Afternoon,

I have a combo box in Excel that has a list of names assigned to it in its input range. I also have these names seperated by worksheets. Is there any VBA code that when a named person is selected in the combo box it will jump to the identical worksheet of the same named person?

Any help would be appriecated,

Cheers,

Mattster

[lucas]

You have a combobox......where? On a userform, on a sheet? Is it created using the control toolbox or the forms toolbar????

Maybe this will help:

http://www.vbaexpress.com/forum/show...ht=combo+sheet

[mattster1010]

Hi Lucas,

The combo box is just on a sheet named "front", its created using the control toolbox... the name of the combo box is drop down 1. I just want the name selected in the combo box to jump to the identically named worksheet.

Cheers,

Matt

[lucas]

did the link help?