I have a commandbutton, when clicked, it opens google.
Here is the code I am using.
Private Sub CommandButton1_Click() Dim chromePath As String chromePath = """C:Program FilesGoogleChromeApplicationchrome.exe""" Shell (chromePath & " -url https://google.com"), vbNormalFocus Unload Me End Sub
This workbook is shared with other people however it doesn’t work on their PC as some of them have a different chrome path and also no idea how to go to the VB editor to make the necessary changes.
Would it be possible to enter the chromepath in a textbox in a userform which then makes the changes in VBE without going to VBE?