Results 1 to 4 of 4

Thread: user form check box
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2015
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default user form check box

    I have a user form that include a check box. If you check the box it runs formulas and puts data in a different column than if it isn't checked. When I open the user form if there is data on the sheet it pulls it in to the user form, and you can modify as needed, however it does not recheck the box. is there away to get the box to be checked if I checked it he first time?

  2. #2
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,799
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: user form check box

    .
    Thinking out loud (in my head ...), if you capture the check when the box is clicked ... in other words, save an indication
    the box was checked by placing an "x" or a "1" or some type of symbol on the worksheet .. then when the form is re-opened
    you can include code to check that cell to determine if it is empty or not.

    If empty ... the checkbox also is empty. If not empty ... the checkbox would be checked.

  3. #3
    Board Regular
    Join Date
    Aug 2015
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: user form check box

    Currently it puts a value or a 0 in the column. What code would I use so it looks at that column and if it is greater than Zero it checks the checkbox?

  4. #4
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,799
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: user form check box

    .
    Something like :

    If Sheet1.Range("A1").Value > 0 then

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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