+ Reply to Thread
Results 1 to 8 of 8

recreate to shorter coding

  1. #1
    Registered User
    Join Date
    06-26-2014
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    16

    Post recreate to shorter coding

    hello,

    please help on my code to shorten


    Please Login or Register  to view this content.
    Please mark your Thread [SOLVED] if post work

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: recreate to shorter coding

    If that code is in a user form's code module, this will shorten one section

    Please Login or Register  to view this content.
    Also, any line like
    Please Login or Register  to view this content.
    can be replaced with
    Please Login or Register  to view this content.
    Last edited by mikerickson; 08-15-2014 at 11:07 PM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    06-26-2014
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    16

    Post Re: recreate to shorter coding

    hi,

    so im gonna remove the =true from my code? ok ill try

    like this?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-26-2014
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    16

    Re: recreate to shorter coding

    for this

    Please Login or Register  to view this content.
    its working now

    but i have so many checkboxes, any suggestion to more shorter? how about renaming checkboxes to numbering or any suggestions?

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: recreate to shorter coding

    Try
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-26-2014
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    16

    Post Re: recreate to shorter coding

    i cant do just
    this code

    Please Login or Register  to view this content.
    because i have this TextBox for specific checkbox

    1.JPG

    2.JPG

    so i think array can do the job, but i dont know the coding for array

  7. #7
    Registered User
    Join Date
    06-26-2014
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    16

    Post Re: recreate to shorter coding

    what if i rename my texboxes will it be more shoter
    example

    Please Login or Register  to view this content.
    i have error else without if
    and how do make it loop?
    Last edited by dragavs; 08-17-2014 at 11:04 PM.

  8. #8
    Registered User
    Join Date
    06-26-2014
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    16

    Post Re: recreate to shorter coding

    PROBLEM SOLVED
    thanks mikerickson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to recreate this chart in excel?
    By bermandl in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-14-2011, 07:05 AM
  2. How do i recreate this graph
    By Selwof in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-09-2009, 12:28 PM
  3. How do i recreate this graph
    By Selwof in forum Excel General
    Replies: 1
    Last Post: 09-09-2009, 08:21 AM
  4. Recreate AutoScroll
    By rjamison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2005, 08:05 PM
  5. Recreate AutoScroll
    By Soli3d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2005, 12:06 PM

Tags for this Thread

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