I really need some help. I have a spreadsheet full of sensitive data so I cant upload it here so I'll explain in detail what I need help with.
I have created a userform that has multiple text and combo boxes that I need to populate from data in the workbook using a reference number search.
Here's what I have:
a textbox and a search button
12 Text Boxes
8 Combo Boxes
2 Check Boxes
I would like to type in a reference number, click search and have the relevant data from the spreadsheet populate the textboxes/combo boxes and then be able to amend the data, click the update button and have the new data overtype the old data within the spreadsheet.
I dont even know if it's possible. I've spent around 5 hours this morning on google and I'm losing the will to live lol.