PDA

View Full Version : Using a combo box to select a named worksheet



mattster1010
06-17-2008, 07:53 AM
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
06-17-2008, 07:58 AM
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/showthread.php?t=10378&highlight=combo+sheet

mattster1010
06-17-2008, 08:05 AM
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
06-17-2008, 08:26 AM
did the link help?