Assuming your GUI is a userform with a ComboBox called ComboBox1 and a
Textbox called TextBox1, take a look at the Change event.

Something like this should do the trick:

Private Sub ComboBox1_Change()
TextBox1.Text = ComboBox1.Value
End Sub

Bill Burke wrote:
Hello,

I am NEW to automating Excel. I have gone into the macro editor and am
"designing" a GUI for a large Excel spreadsheet. Right now I have one drop down
list box and several fields (text boxes). I have figured out how to
automatically populate the list box with values from one of the columns in the
spreadsheet. What I'd like to do now is: Once I select a value in the list box
(server name) I would like for the fields (test boxes on the GUI) to
automatically populate with the appropriate cell values from the row where the
server name appears. I don't know how to do this. Help!!!

Any suggestions will be greatly appreciated.

TIA,
Bill Burke