I've been busy with personal matters, so I apologize for taking so long on getting back here.
I've made the combobox work with regards to 2 columns showing but have run into issues in with how it shows within the combobox. I created a DateTimeList in the Name Manager and had it reference =OFFSET(Thermals!$B$11,0,0,COUNTA(Thermals!$B:$B)-1,2), however, it shows the date and time in alternating rows when you open the combobox in the userform. By adding the coding below, it gives the date as dd/mm/yy and shows the time as a number with decimal places (8.33333333 instead of hh:mm).
Taking a step back to see if I could figure out the search and replace issue, I am still running into the problem of the found data row being entered into a new row instead of replacing the found data with the edited. I tried to use the code below the coding that enters a new row with nothing happening at all except for clearing the form of all but the date and time.
Bookmarks