Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of a way to use a combo box in Excel XP (2002) to link between pages. I know how to create a combo box and get the list in it. But what I would like to do, if possible, is to have each choice link to a different page. Because I have a 31 sheet workbook. I t gets painful to navigate back and forth from page to page. I would like a link on every page to each of the other pages in the workbook, but I do not want a row of 31 links. Thus, I thought about the idea of using a combo box, but if I do that, I can have a list and select, but it won't link to other pages. Help me please.
 
Try right clicking on the sheet navigation buttons - you can then select the
sheet you want.

Regards,

Neal

Jonathan said:
Does anyone know of a way to use a combo box in Excel XP (2002) to link
Click to expand...
between pages. I know how to create a combo box and get the list in it.
But what I would like to do, if possible, is to have each choice link to a
different page. Because I have a 31 sheet workbook. I t gets painful to
navigate back and forth from page to page. I would like a link on every
page to each of the other pages in the workbook, but I do not want a row of
31 links. Thus, I thought about the idea of using a combo box, but if I do
that, I can have a list and select, but it won't link to other pages. Help
me please.
 
I read in your message that you know how to create a list within a combo box. Could you advise me on how to do that. I don't want to choose from a list within the spreadsheet though. I want to separately list my own variables to select from with the combo box being blank in it's "original" form and then the option to select an element when the drop down arrow is chosen.

Thanks in advance

D.C

----- Jonathan wrote: ----

Does anyone know of a way to use a combo box in Excel XP (2002) to link between pages. I know how to create a combo box and get the list in it. But what I would like to do, if possible, is to have each choice link to a different page. Because I have a 31 sheet workbook. I t gets painful to navigate back and forth from page to page. I would like a link on every page to each of the other pages in the workbook, but I do not want a row of 31 links. Thus, I thought about the idea of using a combo box, but if I do that, I can have a list and select, but it won't link to other pages. Help me please.
 
Back
Top