I have a macro below that allows me to open a hyperlink on a different browser. I have assigned this code to a command button (the next set of code). My issue right now is how do I modify this macro so I can assign different websites on different command buttons. For instance, the below website is assigned to CommandButton1. I have CommandButton2 who wants to open msn.com (example only). Please take note, I will be assigning multiple websites on different command button. So, it's 1 website per command button.
Sub LaunchIE() Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.navigate "http://google.com/" IE.Visible = True Set IE = Nothing End Sub
Thank you in advance to anyone who can help me.