locked
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

    • Moved by Dave PatrickMVP Saturday, May 12, 2018 1:43 PM
    • Edited by Richard MuellerMVP Saturday, May 12, 2018 11:53 PM Removed HTML and used code block, fixed typo in code.
    Saturday, May 12, 2018 1:36 PM

Answers