I'll consider that, I'm giving myself a little longer to work through this.
EDIT: SOLVED THE BELOW PROBLEM I had the spreadsheet open, I'm an idiot.
Right now I'm trying to populate the list box from excel but I keep getting error 3450. I f8'd through it and apparently my problem is right here
With rs
.MoveLast
NoOfRecords = .RecordCount
.MoveFirst
End With
Last edited by ericav68; 05-11-2019 at 06:49 PM.
Reason: i fixed it
|