(Solved) – Texbox to setup google chrome path?


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.

My question:
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?

Leave a Reply

Your email address will not be published. Required fields are marked *