+ Reply to Thread
Results 1 to 2 of 2

Userform Checkbox as a value when true

  1. #1
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Userform Checkbox as a value when true

    Is it possible that when a user selects a checkbox on a userform i can add it into a formula on the same userform...

    Example:

    Checkbox1 = 0.92 if selected (true)
    Checkbox2 = 20% if selected (true - note the %)
    TextHours = 8 (as entered by user)
    TextStaff = 2 (as entered by user)


    Formulas wanted: (correct if i am seriously off course here)

    Me.TextTotal = CDbl(TextStaff*TextHours*Checkbox1)

    Me.TextTotal2 = CDbl(TextStaff*TextHours)*Checkbox2 =(remember as a Percent%%)


    i do have set values for each of the checkboxes as required- should i do this separate with a IF/Then staement?

    Another thing to think about when doing the big formula....will it see unchecked boxes as "0"

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Userform Checkbox as a value when true

    i do have set values for each of the checkboxes as required-
    Use the click event of each checkbox to set the Tag property of each control.

    Please Login or Register  to view this content.
    This way, the calculation will be automatic.
    David
    (*) Reputation points appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Get UserForm checkbox caption and pass to another UserForm on click or mouse down
    By tulsaguy71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2013, 11:07 AM
  2. how to make checkbox true selecting then chaning 2nd box true when null
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2012, 01:13 PM
  3. Can't get checkbox to go true from another userform
    By mhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2009, 12:10 PM
  4. make all checkbox = true via a button
    By janjan_376 in forum Excel General
    Replies: 4
    Last Post: 07-22-2009, 04:21 PM
  5. Checkbox: If true all others are false?
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2007, 11:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1