Textbox .value vs .text recent change?

[glfiedler]

I use office 365 on a windows 10 system that Microsoft automatically updated yesterday.
An excel project I wrote some 18 years ago is, today, having issues with userform textboxes. This project has worked well for years and the vba errors occurring today have not been modified.
The error is "type mismatch".
Back so many years ago when I was just learning vba programming I was not aware of the slight difference between the "value" and "text" properties of textboxes. I have learned much over the years, thanks to many of you on this forum, and I thought I now had a pretty good idea of the difference.
Here is a typical section of code where the User enters some text along with a dollar amount in a userform textbox. The code basically changes the sign of the dollar amount and places the text and amount in a worksheet.

With Checking.Range("iDiscoverDate")
            .Offset(blank, 0).Value = PurchaseFM.ActionDate.Text
            .Offset(blank, 1).Value = PurchaseFM.PurDescription.Text
            .Offset(blank, 2).Value = PurchaseFM.Amount.Text * -1
        End With

I changed the code, today, by replacing .text with .value in the "amount" equation:

With Checking.Range("iDiscoverDate")
            .Offset(blank, 0).Value = PurchaseFM.ActionDate.Text
            .Offset(blank, 1).Value = PurchaseFM.PurDescription.Text
            .Offset(blank, 2).Value = PurchaseFM.Amount.Value * -1
        End With

I still get the mismatch error. Do any of you have any ideas why this is not working?

 

[Yongle]

In worksheet formulas ="Truth"="TRUTH" is TRUE, =EXACT("Truth","TRUTH") is FALSE.

@mikerickson
Point proven - what you are saying is that ="Truth"="TRUTH is not EXACTLY TRUE in which case it is FALSE

 

[mikerickson]

In Excel (worksheet formulas), the formula ="Truth"="TRUTH" returns the value TRUE.
Exactly the value TRUE

The worksheet formula (using the Excel's EXACT function) =EXACT("Truth"="TRUTH") returns the value FALSE.

 

[Legacy 456155]

"We could have all lived with a function =ANYCASE("Truth")=ANYCASE("TRUTH") "

the StrComp function?

Well, nevermind. You guys are talking about worksheet functions.

 

[mikerickson]

VBA is different. On a worksheet, = is a case insensitive comparison. In VBA = is case sensitive (depending on the use of Option Compare Text). The WorksheetFunction.EXACT is redundant for VBA.

 

[Legacy 456155]

Gotcha

 

[glfiedler]

My apologies to all of you. In my original post I said I made no changes. Well, like a politician, that statement was "true", regarding the code that I showed you but not completely "TRUE". I had made some changes to the path to the userform. The details of my error are not relevant here, but it resulted in the "amount.text" being undefined. It may have been "null" it may have been "empty" or something else, I don't know and it does not matter. My workbook is working again!
A note of interest: The code works for my purposes whether I use .text or .value or val(name). Thank you for your comments.

 

[GWteB]

No need for apologies and thanks for your honesty & for letting us know.