B
brownti via OfficeKB.com
I am creating a workbook that contains a schedule. I have a userform that
data is entered into and then that is transfered to the worksheet. The
worksheet is then searchable and the results placed in a listbox on the
search userform. I then have it set up so that when a result is double
clicked in the listbox the original userform is displayed with the data from
the list box. I want to make it possible to change this data and replace the
original data with the new data. So basically update the schedule. If
someone could get me started, i can probably figure out how to adapt it to my
needs. Maybe if someone could give some sample code to do the following:
Find value in listbox column 1 in range A1:A500 and value in listbox column 2
in range B1:B500. Then in the corresponding row change value in column A to
textbox1.value and column B to textbox2.value. I hope this makes sense.
Thanks in advance!
data is entered into and then that is transfered to the worksheet. The
worksheet is then searchable and the results placed in a listbox on the
search userform. I then have it set up so that when a result is double
clicked in the listbox the original userform is displayed with the data from
the list box. I want to make it possible to change this data and replace the
original data with the new data. So basically update the schedule. If
someone could get me started, i can probably figure out how to adapt it to my
needs. Maybe if someone could give some sample code to do the following:
Find value in listbox column 1 in range A1:A500 and value in listbox column 2
in range B1:B500. Then in the corresponding row change value in column A to
textbox1.value and column B to textbox2.value. I hope this makes sense.
Thanks in advance!