Macro for users to enter IP address

Hello. I'm newbie in excel VBA and macros bur with the help of this forum I create a little macro. I want to use it to get data from snmp and put it in excel cell. I managed to do this with this macro:

Please Login or Register  to view this content.

Now I want to be able to change the IP address. For example in cell A4 to fill the IP. And the IP to change in the macro. So this macro to be use for different hosts.
And one more little thing. I place a button for this macro and when I press it a cmd windows is popping for 1 second and hide. How can I make it not to show at all.

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#1 and amend your title
Then anyone will be able to help you.