+ Reply to Thread
Results 1 to 8 of 8

Simplifying the code

  1. #1
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229

    Simplifying the code

    is there another way to shorten this code?

    thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello Walid66,

    Here is one version...
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229
    Ok now I have problem selecting different color other than te black color, the script works only on the black color (see attached file). when I start the userform1 and click on the green square top left under the first tab the second userform2 appears and I select the black color the green button changes to black. If I pick different color it stays black. I am not sure where the goes getting stuck. The excel file is 845kb and little big to attach it.
    Attached Files Attached Files

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello Walid66,

    Can you attach your workbook? The images aren't helping me to understand your problem.

    Thanks,
    Leith Ross

  5. #5
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229
    the file is over the limit which 845 kb is there other way I can send it to you beside uploading.

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello Walid66,

    You can email me at LeithRoss@gmail.com.

    Sincerely,
    Leith Ross

  7. #7
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello Walid66,

    If I understand this correctly, you want to use the colors from the second UserFrom, image controls 1 through 7, only if the the user has selected one of those, right?

    Thanks,
    Leith Ross

  8. #8
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229
    yes if the user select one of the 7 square boxes on the userform1 the second userform2 will pop up and they can select any color to change the color from 1 to 7.

+ 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