+ Reply to Thread
Results 1 to 3 of 3

Condition code True False on Checkbox

  1. #1
    Registered User
    Join Date
    12-12-2006
    Posts
    33

    Condition code True False on Checkbox

    Hi again,
    I am playing around with checkboxes to see how to control events such as clicks
    I have coded a very basic sheet to teach me return values of acheckbox variable that is not working as I would expect.
    The code I am using is
    Please Login or Register  to view this content.

    I have attached the spreadsheet so you can see what happens when you click each checkbox
    I would have thought that Cells G1:G3 would have the values
    and that F1:F3 would have the dates.
    what did I do wrong ?

    Also as you can see I tried Private for checkbox1
    not sure exactly what Private will do or not do but neither of the checkboxes work as expected
    any information about when to use private vs not would also be appreciated.

    Happy Holidays
    RobertCo
    Attached Files Attached Files
    Last edited by VBA Noob; 12-16-2006 at 08:01 AM.

  2. #2
    Registered User
    Join Date
    12-12-2006
    Posts
    33
    I think I figured it out although I still do not know why.....

    There are two types of checkboxes,
    On from the forms toolbar and one from the control toolbox.....
    Why the difference in what they do ?



    attached is the new spreadsheet with using the control toolbox Checkbox's

    works as espected but again not sure what the differences are.
    Attached Files Attached Files
    Last edited by RobertCo; 12-16-2006 at 12:42 AM.

  3. #3
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by RobertCo
    I think I figured it out although I still do not know why.....

    There are two types of checkboxes,
    On from the forms toolbar and one from the control toolbox.....
    Why the difference in what they do ?



    attached is the new spreadsheet with using the control toolbox Checkbox's

    works as espected but again not sure what the differences are.
    Either can work 'as expected' - it just depends what you expected, see the attached two sets for different response.

    The Forms version needs 'assign macro', whereas the Toolbox version expects own code, but the code follows only what you put in.

    hth
    ---
    Attached Files Attached Files
    Si fractum non sit, noli id reficere.

+ 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