Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

Right-click the list box and select "Format Control" from the menu. Enter the coordinates of an empty cell into the box labeled "Cell Link." Choose the cell where the data from the list box should ...

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the ...