Hello,
I am having trouble with a spot of VBA, that should be easy..
I have a Form with a lot of list boxes (32)… each has queries calculating different fields but their columns line up. I am hoping to sum up column(7) of each listbox, and entering the total into a textbox on the same form
I have tried using various scripts to pull the list box value (it is a double.. more specifically currency), as an example I was going to use this:
With lstbox
MsgBox (.Column(6))
tbTotalRRPREM = .Column(6)
End With
in troubleshooting the above message box states the value is null, but the lstbox is definitely not null..