URL link in message box

Hi All,

I've done a bit of reading up in this topic and managed to find and modify code for 2 methods to activate a link in a message box.

Method 1: Using a simple message box sourcing code here: https://stackoverflow.com/questions/...n-a-messagebox

Please Login or Register  to view this content.

triggered when a cell value is changed via a drop down box

Please Login or Register  to view this content.

Method 2: Using a more complex userform method which i don't fully understand to be honest but it looks great. Everything is perfect but unfortunately i can't quite get the hyperlink to execute. When clicked it goes to windows explorer rather than website link added ("www.google.com") for test purposes.

Working test file attached with code for both which should be quite self explanatory.

How to use:
edit: If green cell D7 is changed it will bring up the method 1 message box, if yellow cell D5 is changed it will bring up method 2 message box.

At the moment i'm using Method 1 but would prefer to use Method 2 if i can get it to work.

Your second method worked fine for me. Opened up in my default browser.

If yellow cell D7 is changed it will bring up the method 1 message box, if green cell D5 is changed it will bring up method 2 message box.

Your description is a bit scrambled. The code you labelled as Method 1 above runs when the green box in D7 is updated.

Sub Yellow is triggered by D5, the yellow cell. Your original code explicitly opens Windows Explorer. Whoever wrote the code probably thought Explorer.exe referred to Internet Explorer. I have modified your code to use a Shell command, the same way the other option works.

Module1 had a superfluous copy of the code from the form, which is useless and confusing, so I removed it.

I modified the command in the Yellow version (the form you like) to use a command similar to the Green version. It will use your default browser.

In the Sub HLinkMsgBox, there is no need for a With for the form. Every reference will default to objects in the form. I removed it.

I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bug and runtime errors.

They both work now, see attached.