View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
randallwilkins[_3_] randallwilkins[_3_] is offline
external usenet poster
 
Posts: 1
Default Populate a form with data from a range


I am using VB in Excel. This is the code for one of the fields:

Private Sub txtOilGuage_Change()

End Sub

I want to lookup a well name that was picked in a combobox, look for
that well on another worksheet, and populate all the other fields in
the form with data from that row.

Find the well, look in each of the columns across the row and put the
value in the respective field on the form.


--
randallwilkins
------------------------------------------------------------------------
randallwilkins's Profile: http://www.excelforum.com/member.php...o&userid=35054
View this thread: http://www.excelforum.com/showthread...hreadid=553375