Macro to run URL web site RRS feed

  • Question

  • Below is a simple macro that opens in www.msn.com

    Sub Open()
        ActiveWorkbook.FollowHyperlink Address:="www.msn.com"
    End Sub

    Is there a way to use input Box to enter an web address? I would like to use input box for each new web address without going into the macro above each time to change the address.

    I am using excel 2010

    Thank You

    Bill Morgan

    email: bzmorgan@att.net

    Saturday, May 12, 2018 1:36 PM