Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create error msg based on formfield calculation result using VBA
Thanks for your response PH. I had the sign facing the wrong way in my initial post so that it should read when text36 is GREATER than text39, then display msg: If Val(oFld("Text36").Result) > Val(oFld("Text39").Result) Then...and this works in every instance except for one, which is what's...- KimsMisc
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Create error msg based on formfield calculation result using VBA
I have a protected Word 03 form with a 2 column table in it (A1:B8). In the table are 3 manual entry textbox fields that you can enter dollar amounts into (B1, B2 & B3), and the remaining 5 fields (B4, B5, B6, B7 & B8) have formula calculations. B4 is the sum of B2+B3. B5 is a percentage ratio...- KimsMisc
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
