Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a combo box of hyperlinks?
I have an extensive list of clauses in an excel file. I want to have a drop
down box that identifies the names of each of the clauses. The kicker is that I want the names in the drop down box to be hyperlinks. Drop down to "Auto-Extension Clause" and automatically be linked to the spot in the worksheet. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a combo box of hyperlinks?
hi, Laura !
you could use hyperlink (WF) in an helper cell/column to build the address according your combobox... see David McRitchie' page: - Coding a link address and friendly name using HYPERLINK Worksheet function http://www.mvps.org/dmcritchie/excel....htm#hyperlink hth, hector. __ OP __ I have an extensive list of clauses in an excel file. I want to have a drop down box that identifies the names of each of the clauses. The kicker is that I want the names in the drop down box to be hyperlinks. Drop down to "Auto-Extension Clause" and automatically be linked to the spot in the worksheet. Is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a combo box of hyperlinks?
Thanks for the reply, Hector. That just might do the trick. I'll give it a
shot on Monday! Have a great weekend! Laura "Héctor Miguel" wrote: hi, Laura ! you could use hyperlink (WF) in an helper cell/column to build the address according your combobox... see David McRitchie' page: - Coding a link address and friendly name using HYPERLINK Worksheet function http://www.mvps.org/dmcritchie/excel....htm#hyperlink hth, hector. __ OP __ I have an extensive list of clauses in an excel file. I want to have a drop down box that identifies the names of each of the clauses. The kicker is that I want the names in the drop down box to be hyperlinks. Drop down to "Auto-Extension Clause" and automatically be linked to the spot in the worksheet. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create combo box in excel | Excel Discussion (Misc queries) | |||
Create a list box/combo box with hyperlinks | Excel Worksheet Functions | |||
how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
validation list or combo boxes with hyperlinks | Excel Discussion (Misc queries) | |||
Combo box with data to use as hyperlinks | Excel Worksheet Functions |