Hi, I know that there are several ways to input url's into excel, but I am creating a sheet for users with little to no excel experience. One of the features I would like to include is a step by step process for them to input urls. I would like them to be able to push a button and have a dialog box open where they can paste a url, then once this is done I would like to have a new dialog box open that asks them for a simple name for their url. I would like this to be saved in what ever active cell they are in when they push the initial button.
I guess the example would be
1) They are in cell A4 and push a button that says "Input URL".
2) The a dialog box opens with instructions to paste a url so they copy and paste "http://www.excelforum.com/forum-rules/642590-forum-rules.html" from their address bar and hit "save"
3) A dialog box opens and asks them for a friendly name for their url and they type "Excel Form Rules"
4) A Hyperlink with the description "Excel Forum Rules" appears in cell A4.
I hope this is a clear explanation of what I want to do and that there is a way to do so.
Thanks.
Bookmarks