+ Reply to Thread
Results 1 to 7 of 7

How to set conditions when using form or activex controls

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    How to set conditions when using form or activex controls

    I need to figure out how to make my sheet work based on conditions. In the example I've attached I need help with the following:
    1. Add a button to be clicked that if $G$2=true, then $C$5=$C$4*2
    2. Add a button to $F$5 and another to $F$6. Then if $F$5=true, both of my formulas calculate as they're written already.

    Then I need the condition... If the button in $B$5= TRUE, then $F$5 MUST be False.

    In simple terms, if we have a customer who chooses a 2 year contract they are unable to use monthly payments and hence that set of boxes must remain "N/A".

    Is it possible to create a pop-up to state this that if the button in $B$5 is clicked and someone attempts to click on yes for monthly payments to state this can't be done?

    Last question- should I use form or activex controls?

    I also want to mention that I'm very much a novice and have never dabbled in VBA code- so please dummy it down to help ensure I "get it". I'm using excel 2013.

    Example.xlsx

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How to set conditions when using form or activex controls

    Hello robstark,

    The Yes and No buttons are not needed. Your formulas have taken care of alerting the user to what applies and what does not. Are you looking to create a VBA USerForm instead of using the worksheet and formulas?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: How to set conditions when using form or activex controls

    I'll use whatever is easiest... for me and my limited knowledge base it's easier to keep the worksheet and formulas, but if there's a better way then I'm all ears.

    My formulas take care of the calculations, but I'd like to have the user click on the button to trigger the formulas to calculate.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How to set conditions when using form or activex controls

    Hello robstark,

    I find this part confusing because the formulas calculate automatically once the user makes an entry.
    My formulas take care of the calculations, but I'd like to have the user click on the button to trigger the formulas to calculate.
    Do you have an example of this not happening?

  5. #5
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: How to set conditions when using form or activex controls

    I use if statements though and it relies on the "true" statement

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How to set conditions when using form or activex controls

    Hello robstark,

    If you are bothered by the True/False results being visible, change the cell font to match the color of the worksheet.

  7. #7
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: How to set conditions when using form or activex controls

    That part I get... However this isn't solving my situation. Maybe I wasn't as clear as I needed to be.

    I need the option for monthly payments to not be allowed if someone chooses a 2 year contract. As it's set up now both options can be chosen which is what I need to avoid from happening.

    I also need advice on using form controls or activex controls to make this happen. I was using a form control, but wasn't/not sure if that's the best option.

+ 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. Replies: 2
    Last Post: 11-16-2012, 04:35 AM
  2. ActiveX vs. Form Controls: File Size
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2012, 02:31 PM
  3. Form & ActiveX Controls
    By John Bates in forum Excel General
    Replies: 11
    Last Post: 03-05-2011, 03:59 PM
  4. Form controls vs. ActiveX controls
    By wmorrison49 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2008, 10:59 AM
  5. ActiveX Controls vs Form Controls
    By Alex in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 04:50 AM

Tags for this Thread

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