We have a macro for users to run. One user has Excel 2007. Would this version be the reason the following code fails on the "TRIM" function? I works in 2010 and later.
or
Code:
theAnswer = UCase(Trim(Cells(ques, 2).Text))
or
Code:
theCaption = UCase(Trim(UserForm1.Choice1.Caption)) ' This is reading a RadioButton caption