Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names in Combobox are hyperlinked to cells
Hi I have a combobox that shows several names..... the point i want is when i select a name from drop-down combobox, s the chosen name should work as a hyperlink to other cell within th same sheet i.e. when choosing a name, it should take me to a preselected cell names in combobox shoul be hyperlinked to other cells within the sam sheet. hope it is clear yours -- helmekk ----------------------------------------------------------------------- helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693 View this thread: http://www.excelforum.com/showthread.php?threadid=27097 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names in Combobox are hyperlinked to cells
Private Sub ComboBox1_Change()
If ComboBox1.ListIndex = 0 Then Range("K20").Activate 'first name If ComboBox1.ListIndex = 1 Then Range("K21").Activate 'second name End Sub Do this for each name in your list and change the range to your needs. Mike F "helmekki" wrote in message ... Hi I have a combobox that shows several names..... the point i want is when i select a name from drop-down combobox, so the chosen name should work as a hyperlink to other cell within the same sheet i.e. when choosing a name, it should take me to a preselected cell names in combobox shoul be hyperlinked to other cells within the same sheet. hope it is clear yours h -- helmekki ------------------------------------------------------------------------ helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 View this thread: http://www.excelforum.com/showthread...hreadid=270974 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Hyperlinked Cells | Excel Discussion (Misc queries) | |||
How can I sort hyperlinked cells? | Excel Discussion (Misc queries) | |||
set hyperlinked cells to always display at the top of the workshee | Excel Discussion (Misc queries) | |||
locked hyperlinked cells | Excel Discussion (Misc queries) | |||
How to lookup hyperlinked cells | Excel Programming |