Use a command button to activate a hyperlink

Hi,

I am completely new to VBA and writing macros.

I am trying to write a macro that activates the following funtion in cell D1.

=HYPERLINK("#"&C2,"")

I have recorded the following macro but it only jumps to the cell the function is in rather than actually activating the function and jumping to reference which has been selected in C2.

Thanks for your help.

Please Login or Register  to view this content.

Hello penfold,

Here is the VBA code...

Please Login or Register  to view this content.

If I remember correctly, hyperlinks created by the formula method aren't accessible through VBA code.

Sincerly,
Leith Ross

Thank you.

I can't get this to work, even with a standard hyperlink.

Is this all the code that is required or should I be adding it to other code?

Please can you give me the full code from begining to end.

I'm grateful for your help.

Thanks

Hello penfold,

The code I posted assumes the hyperlink to be on the ActiveSheet. If it is not then you should qualify the reference with the worksheet name, like this...

Please Login or Register  to view this content.

This code works if the hyperlink was added to the cell using VBA code or you inserted it using the context menu. If you still have problems, it would be best for to post your workbook for review.

Sincerely,
Leith Ross

Hi Leith,

Sorry, I can't seem to win.

I have posted the workbook.

Thanks for your help.

Hello penfold,

I am having a problem downloading your file. The forum is sluggish right now, so that may be the problem. I will keep trying. If I can't download the file, you can email me at [email protected]. I can then review it and repost it for you.

Sincerely,
Leith Ross

Emailed as per you reply.

Many thanks

Hello everyone,

I promised to post with a solution. Here is the macro used to select and display the client list. Hyperlinks weren't needed since all the elements of the list were named ranges. These names appear in a ListBox that user can select from. When the user clicks the command button the entry is then scrolled into view. The attached workbook has the macro installed.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith,

Curently the list box input range is in the same worksheet.

When I move the input range to a separate worksheet the macro stops working.

I have tried to qualify the reference without success.

Can I ask for your help yet again?

Thanks

Excellent, thank you.