We are using VNC in house to do remote control between workstations.
As there are over 25 of them, I would like to set up a little macro in
Excel (2003) that when run, displays a list of user names along with a
box prompting for which # on the list you want to connect to.

Here's what I have so far:
----
Sub RunVNC()

Shell ("c:\program files\hyena\vncviewer.exe sv-ws6")

End Sub
----
I would like to see something like:
1. Payroll
2. Receivables
3. Accountant
4. Reception
Please enter the number to connect to:

Typing 1 and pressing ENTER would run the Shell command above.

Can anyone help??

TIA, Alan