Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Malleable GUI forms (Word2000 et al.)

    If I've done it right .... the attached (zipped) template will demonstrate a means of loading a GUI form with checkboxes and labels derived from a table in a source document (in my example held in the template itself).
    The table is scoured for rows whose leading character matches the leading character of a page in a multi-page control.
    Each page is loaded with data for its specific category.
    Rows with no matching page are ignored.
    I placed 15 pairs of checkboxes and labels on each page, so for this demo, 15 is an upper limit.

    Clicking "OK" on the GUI form delivers a delimited string of delimited substrings; each page arrives as a string delimited by vbCrLf; each string of page data arrives as a string delimited by vbTab characters.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Malleable GUI forms (Word2000 et al.)

    Surely it should be called a "Gooey GUI" rather than a malleable one? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Malleable GUI forms (Word2000 et al.)

    >Surely it should be called a "Gooey GUI" rather than a malleable one?
    Good one!
    Did you get it to work?

    Sticky point: should I cut-and-run or cut-and-paste?

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Malleable GUI forms (Word2000 et al.)

    Chris

    I get a Run-time error '13' but no obvious break in the code <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Jerry

Posting Permissions

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