Hi, I would like to open IE with a predefined web address detailed in cell A1. How can I create a button to do this?

I have looked around but all codes seem to be to open a dedicated website. I want the cell A1 to be dynamic i.e. a VLOOKUP cell so the address can change dependant upon a drop down list.

Specifically I want the button to open up an ip address in cell A1 (e.g. 192.168.112.78.. etc) and also I would like to add on to open port 8080. e.g. :8080 as this is to open a modem interface on the network.

Finally the modem has a user name and password, is it possible to add this into the code somehow to automatically open the modem interface page. e.g. username in B1, password in C1

cheers