General discussion

Locked

Combo Boxes

By gr8pctech ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Combo Boxes

by RichTee In reply to Combo Boxes

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

Collapse -

Combo Boxes

by gr8pctech In reply to Combo Boxes

Thanks for all your help. The information is exactly what I needed.

Collapse -

Combo Boxes

by gr8pctech In reply to Combo Boxes

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums