Need simple VBA code to open Internet Explorer with URL based on cell reference

[slrdude]

I know this is pretty basic, but I have a list that contains thousands of call records and I need a macro that will open a selected URL with Internet Explorer to link directly call audio itself.

The hyperlink is the result of concatenating a static hyperlink with a number that is unique to each call. For example:
My base hyperlink is: http://www.disboards.com/showthread.php?t=3120360&page=
The Call ID is: 2
The resulting hyperlink is: http://www.disboards.com/showthread.php?t=3120360&page=2

I have attempted =HYPERLINK("http://www.disboards.com/showthread.php?t=3120360&page="&[Cell Reference],"Call Audio") but the web application that plays calls doesn't work with that method. However, copying and pasting or opening IE directly with that link will work perfectly.

Please see the attached file and let me know how to accomplish this.
example.xlsb

[Leith Ross]

Hello slrdude,

Welcome to the Forum!

I have modified your workbook to open the page simply by double clicking on the page number in column "B". There are two macro to do this.

Worksheet BeforeDoubleClick Event Macro Code

Please Login or Register  to view this content.

Module1 - Macro to Open the Web Page using a Number

Please Login or Register  to view this content.