Edit VBA textboxes in userform|VBA & Macros|Excel Forum|My Online Training Hub

Hi,

I'm building a Hazard reporting Database with very long Advanced data with headings with comboboxes and text boxes. All work well in my SafetyChampReport1 userform.

However, in my SafetyChampReport2. I wanted to create a 'Lookup" and "edit" userform with listbox where its taking data from the advanced data.

I can double click the list box and select a line that you want to retrieve and puts all the information into various boxes on userform. There is for some reason the information in the listbox disappears but that's another thing.

What I am after, in the "edit overview" button, where in various textboxes to edit and update the advanced data in sheet2 (Excel Dump). 

I had this code before in my previous database and works well but for some reason this edit doesn't seem to update.

I can provide you with the code but if you can download my excel and hit ALT F11 and go to SafetyChampReport2 and hit Edit overview.

Thanks

Steve