Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Make text cells and combo boxes required? | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
filling combo boxes from single outer source | Excel Discussion (Misc queries) | |||
Filling form text boxes from cells. Incredibly simple I know, but I'm new. :-( | Excel Programming |