ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   filling text boxes from a combo box (https://www.excelbanter.com/excel-programming/323685-filling-text-boxes-combo-box.html)

JT[_2_]

filling text boxes from a combo box
 
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.

Tom Ogilvy

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.





All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com