View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default filling text boxes from a combo box

You can keep the same row and update the information. I gave you code on
filling the textboxes.

Just loop through your list and find the row (recall that the first row is
zero based).

then

..list(rw,columnNumber) = Textbox1.Text

as an example.


--
Regards,
Tom Ogilvy

"JT" wrote in message
...
I have a form with 6 text boxes and a combobox. I have
been able to add data from the text boxes to the combo
box.

What I would like to do know is let the user select a row
from the combobox and populate the 6 text boxes with the
data (where they can edit the data)

AND (2) once the data has been changed I want to update
the combobox with the new data.

Will I have to delete the combobox row and add a new row
or can I keep the same row and just update the
information.

Any help getting started would be appreciated. Thank you.