I have created excel project database using excel Userforms. First request form capture the customer inputs and store in Request_database sheet, which contains 12 columns (A to L). Now I frequently update Hold Status column manually.
Now I created a editable User form which will read all the data by the help of list index, but when I update data it will not take on same row its added to next row because of .offset code, I need to replace code which will update on the same row.
Please Help on this.
Private Sub cbocompdate_Change()
cbocompdate.Value = Format(Me.cbocompdate.Value, "dd mmm,yyyy")
Private Sub cboend_Change()
cboend.Value = Format(Me.cboend.Value, "dd mmm,yyyy")
Private Sub cboread_Change()
cboread.ListIndex = cboeco.ListIndex
Private Sub cboreq_Change()
cboreq.Value = Format(Me.cboreq.Value, "dd mmm,yyyy")