View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Burke Bill Burke is offline
external usenet poster
 
Posts: 4
Default Newbie - populate (macro) GUI from Excel cells

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