Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shape Values w/counting (Word2003)

    Anyone have any ideas. I'm trying to count the true and false value of the shapes (Checkboxes) in a folder. Any help would be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shape Values w/counting (Word2003)

    Shapes in a folder?

    Do you want to count check box values in a document? Or in all documents in a folder?
    What kind of check boxes? From the Forms toolbar or from the Control Toolbox?
    Please try to provide clear and sufficient information.

  3. #3
    Star Lounger
    Join Date
    Apr 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shape Values w/counting (Word2003)

    Sorry. All documents in a folder. From the control Toolbox, then formatted to float above or behind the text.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shape Values w/counting (Word2003)

    Do you want an overall count (1365 True and 1207 False) or do you want a break down per document (Document1 12 True and 13 False, Document2 17 True and 9 False, etc.)?

  5. #5
    Star Lounger
    Join Date
    Apr 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shape Values w/counting (Word2003)

    Either way would be great. Overall count would be best. Thanks Much HansV.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shape Values w/counting (Word2003)

    See the attached code. Substitute the path of your folder.
    Attached Files Attached Files

  7. #7
    Star Lounger
    Join Date
    Apr 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shape Values w/counting (Word2003)

    Works great. HansV your always so helpful, I really appreciate all your help.

  8. #8
    Star Lounger
    Join Date
    Apr 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shape Values w/counting (Word2003)

    Don't mean to be a pain, but you help with counting those same shapes which have a certain 3 characters in the right of the shape name. Is that possible?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shape Values w/counting (Word2003)

    You can use something like

    Dim intCount As Integer

    near the top of the procedure, and the following

    If Right(shp.Name, 3) = "XYZ" Then
    intCount = intCount + 1
    End If

    within the loop.

  10. #10
    Star Lounger
    Join Date
    Apr 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shape Values w/counting (Word2003)

    Your excellent HansV, thanks Much

Posting Permissions

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