Macro for users to enter IP address

[haunted]

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:

Sub snmp()
Set s = CreateObject("wscript.shell")
      Set s = s.exec("c:\snmpget -q -r:192.168.0.100 -t:10 -c:public -o:.1.3.6.1.4.1.32111.1.5.1.8.0")
      Range("B4").Select
      ActiveCell.Formula = s.stdout.readall
End Sub

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.