+ Reply to Thread
Results 1 to 7 of 7

Combo generator

  1. #1
    Registered User
    Join Date
    10-23-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    MS for Mac 2011
    Posts
    3

    Lightbulb Combo generator

    I have a padlock for my boss that has 4 dials and different letters on each dial. Is there a way for me to create a generator in excel of what words she could make with the letters? She wants to know all the options, so she can pick out the one she likes that would stick in her brain best.

    dial 1 - JMDBNLTSRP
    dial 2 - HLTRYUOIEA
    dial 3 - ROEDCANLTS
    dial 4 - YKHDENLTSR

    Thanks

    Keith

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Combo generator

    I realize this isn't in the VBA Forum, but here is a VBA Solution....I think it does what you want...

    Please Login or Register  to view this content.
    this generates 10000 choices....

    EDIT: The ColCnt is really not needed....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Combo generator

    did this work for you?

  4. #4
    Registered User
    Join Date
    10-23-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    MS for Mac 2011
    Posts
    3

    Re: Combo generator

    Hi Judgeh59,

    Honestly, I have no clue what to do with your response. I am barely savvy on excel much less VBA. I had to google VBA. I think I need to take some classes on excel to be honest. Thanks for trying to help though.

  5. #5
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Combo generator

    Don't worry about that at all...I have uploaded a file with the macro in it. All you have to do is click the big start button...

    so here is what is happening

    the macro loops uses nested loops.
    it goes throught the inner loop (d) and then to loop (c) and then (b) and lastly (a)...
    it outputs 4 characters each time giving you what all the combos are....

    you then have to decide what "looks" right for a combo...

    again, don't worry to much about not knowing XL or VBA....there are plenty of great folks in this forum to help....just ask the question and somebody will answer....

    hope this helps
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-23-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    MS for Mac 2011
    Posts
    3

    Re: Combo generator

    WOW! That was awesome! Thank you so much! I definitely need to take some classes to learn more complex excel stuff, but for now I will definitely use this forum.

  7. #7
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Combo generator

    I'm glad you like it. You're welcome and thanks for the rep points....keep asking questions and have fun...

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Replies: 19
    Last Post: 09-06-2014, 06:30 PM
  2. Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes
    By dovermac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2014, 10:09 AM
  3. Replies: 8
    Last Post: 12-26-2013, 02:23 PM
  4. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  5. number combo generator?
    By yungexec in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-03-2005, 09:38 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