User Input Box as Dropdown

Good Morning All,
I am currently automating a process where we pull reports off of different servers. Right now I have a user input box that asks them to enter the IP Address of the Server. I would like it to show up with a little drop down so they can select the server from the list instead of typing in the whole IP Address and also if possible in the Drop Down list I would like it to show the ServerName instead of the IP so people don't have to look up which server is which. For Example the servers are:

IP Name
123.456.789 ABC Server
456.789.123 DEF Server
789.123.456 GHI Server

I would like the list to have the server name but when it goes to conect I need it to use the IP address.

This is the current Input Box code I am using.

Please Login or Register  to view this content.

I assign variables.

Please Login or Register  to view this content.

I then have it check to ensure you are not already connected to that server. If the application is open it pulls the report. If it isn't it logs in using login password entered by user.

Please Login or Register  to view this content.

The work book is only one sheet for now. would you like me to just post the code form the macro that I am trying to do?

Here Is the workbook I am working in. The macro runs pulls my report and imports it into the CMS Data sheet.