Macro to run URL web site

• Question

• 

  

  0

  Sign in to vote

  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, Banned Saturday, May 12, 2018 11:53 PM Removed HTML and used code block, fixed typo in code.

  Saturday, May 12, 2018 1:36 PM