Ok, it's been a long time since my college classes on vb scripting, so I'm hoping for a point in the right direction.

In an Excel spreadsheet, on one tab, I have a list of about 200 servers and how they appear on racks in our datacenter. It's a rough visual map of the center. On another tab I have all the information regarding each server.

Is there a way to click on a server name, or a button next to it if that's what I have to use, and in so doing have a text box populate with information from the second tab regarding that server? I know how to do a simple vlookup to find that information, but how do I script it so that by clicking in the cell, or a button, it populates a text box with that info?

Sorry if this is a bit confusing, or even if it's a bit too much for someone as rusty as myself. But any help is MUCH MUCH MUCH appreciated.