Addition of 2 fields based on checkboc true or false

Status
Not open for further replies.

George Z

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
I have an outlook custom form where I would like to set a text box to add the sum of 2 fields based on a checkbox entry being true. Though not a valid formula here is what I am looking to do.

"IF [Rate Or After Hours Checkbox]=True THEN [Total Travel Cost]+[Total Labor Cost Rate]"
 
Thank you Diane. Works Beautifully. Some of this VBA is beginning to make sense. I know..... Scary!
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
T Request Addition to Code- convertMail to AccountAppt (from www.Slipstick) Using Outlook 16
C View doesn't refresh (fields or formatting) Using Outlook 1
M Accessing ALL Outlook contact fields Outlook VBA and Custom Forms 3
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
J Read Outlook Form fields Outlook VBA and Custom Forms 3
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
S Reference Custom Fields with VBA Outlook VBA and Custom Forms 2
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
S User Defined Fields adding new value (2) Using Outlook 0
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
T Outlook 2010 Correct way to map multiple contact fields Using Outlook 4
F Appointment Show All Fields Using Outlook 1
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
cimbian street address fields contain 0A0D Outlook VBA and Custom Forms 2
S Custom user fields in received messages Outlook VBA and Custom Forms 1
J Backup .OST - Custom Contact Forms, Defined Fields, Notes Using Outlook 1
P Outlook custom fields "events" Using Outlook 0
J Add Fillable Fields to Existing Template Outlook VBA and Custom Forms 1
B Customize contact record phone fields Using Outlook 2
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
R User Defined Fields adding new value Using Outlook 3
S VBA with User Defined fields Outlook VBA and Custom Forms 9
Diane Poremsky Add Attachments and Set Email Fields During a Mail Merge Using Outlook 0
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
H How to export *all* fields from Outlook Using Outlook 2
L Change the displayed fields in calendar view Using Outlook 1
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
M Recurrence and custom fields Outlook VBA and Custom Forms 0
Diane Poremsky Hiding Global Address Book Fields Using Outlook 0
M Map Outlook user defined fields onto a Sharepoint list ??? Outlook VBA and Custom Forms 1
L Copy email body fields to excel Using Outlook 0
Diane Poremsky Add attachments and set email fields during a mail merge to email Using Outlook 0
H User designed fields not usable in contact folder views Using Outlook 0
L Outlook 2007 Search All Fields in Contacts Using Outlook 1
N How to retrieve user defined fields values to bcm form. Using Outlook 2
N How to disable user defined fields in BCM forms Using Outlook 2
M Adding fields to Task in Outlook Home and Business 2010 Outlook VBA and Custom Forms 7
W Meeting printing background fields Using Outlook 0
N Outlook 2013 vs Outlook.com Email Address fields Using Outlook.com accounts in Outlook 1
S Fields in BCM are overlapping BCM (Business Contact Manager) 2
U Cannot access fields at bottom of Outlook 2013 Contact Rec. Using Outlook 1
C Outlook Custom Contact Form Attach Files in new notes fields Outlook VBA and Custom Forms 3
K User Defined Fields in Outlook 2010 Using Outlook 2
S Custom Outlook Form 2013 Displaying fields incorrectly Outlook VBA and Custom Forms 1
J Do fields in Outlook have ID's? Using Outlook 1
M Predefined Outlook Fields not available to add into a BCM record BCM (Business Contact Manager) 0
A phone numbers fields in BCM are not correct BCM (Business Contact Manager) 3
P User-Defined Relationship Fields: Invisible? BCM (Business Contact Manager) 0

Similar threads

Back
Top