+ Reply to Thread
Results 1 to 2 of 2

Simple Task, but need help

  1. #1
    Registered User
    Join Date
    01-14-2004
    Posts
    34

    Simple Task, but need help

    I've been asked by my manager to add something to my spread sheet.
    Before a formula is executed, he wants me to add 4 check boxes that need to be checked off before the forumal works.

    I cannot disclose the full formula, but here's an example:
    =D10/2

    It's simple, but I cannot figure out how to integrate the check boxes with the formula. I made 4 check boxes already...

    Thanks

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845
    alexm999,

    Not sure if it can be done the way you want, but you can create or add to your code to check the value of the checkbox', and if all are "True" then have your code input the formula. However some one may have away.

    If Sheets("Sheet1").CheckBox1.Value = True And Sheets _("Sheet1").CheckBox2.Value = True Then
    Range("D10").Formula = "Your Formula"
    End If

    HTH

    Charles

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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