Maxicus
02-19-2018, 02:51 AM
21646
I am working on a user-form to which will add data to a sheet (in this example sheet2) and then can be recalled and deleted if needed.
What i have done so far:
able to add new entries from the textboxes to sheet2.
able to populate the listbox with the data on sheet2.
What I can't seem to get to work and need to do:
if you click on one of the items within the listbox, to repopulate the 4 textboxes with that information. and
find the row that matches the 4 textboxes and delete the data on the sheet when pressing the delete button.
I have also set up a dymanic name range on the sheet called "People". if that helps. the dynamic name range is from A2 to D6
I am working on a user-form to which will add data to a sheet (in this example sheet2) and then can be recalled and deleted if needed.
What i have done so far:
able to add new entries from the textboxes to sheet2.
able to populate the listbox with the data on sheet2.
What I can't seem to get to work and need to do:
if you click on one of the items within the listbox, to repopulate the 4 textboxes with that information. and
find the row that matches the 4 textboxes and delete the data on the sheet when pressing the delete button.
I have also set up a dymanic name range on the sheet called "People". if that helps. the dynamic name range is from A2 to D6