Software

Ask something
Discussion Locked

Combo Boxes

0 helpful
3 replies

by gr8pctech

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am working in excel and I would like to be able to add hyperlinks within a combo box. I have been unable to find out how to do this, so I am asking for some assistance.

Thanks

3 replies

by richtee

Assuming the range of cells that make up the list of Hyperlinks are formatted as hyperlinks AND you know the cell where to place the selected Hyperlink. (The list can be anywhere in the Workbook and not need be on the same Sheet as the Combo box orthe outpout).

Enter the range for the list of Hyperlinks into the Combo Box ?ListFillRange? property.

Enter the cell where you want your output to go in the Combo Box ?LinkedCell? property

Now the last step is the must: Manually enter one of the hyperlinked address directly into the ?LinkedCell?. Doing this will now format the cell so that future entries that are put here by selection from the combo Box will be hyperlinks that can be launched on the click event.

Hope this helps. Rich

This discussion is closed to new replies.