Why is TRIM function failing in VBA?

[ez08mba]

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.

theAnswer = UCase(Trim(Cells(ques, 2).Text))

or

theCaption = UCase(Trim(UserForm1.Choice1.Caption)) ' This is reading a RadioButton caption

 

[DanteAmor]

I've been trying to get a screen shot from the user

You could upload a image file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.