+ Reply to Thread
Results 1 to 7 of 7

Combo generator

  1. 10-23-2014, 04:15 PM #1
    keifer77
    keifer77 is offline
    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
    Reply With QuoteRegister To Reply
  2. 10-23-2014, 04:41 PM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    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....
    Reply With QuoteRegister To Reply
  3. 10-24-2014, 10:07 AM #3
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Combo generator

    did this work for you?
    Reply With QuoteRegister To Reply
  4. 10-28-2014, 03:38 PM #4
    keifer77
    keifer77 is offline
    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.
    Reply With QuoteRegister To Reply
  5. 10-28-2014, 03:53 PM #5
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    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
    Reply With QuoteRegister To Reply
  6. 10-28-2014, 04:47 PM #6
    keifer77
    keifer77 is offline
    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.
    Reply With QuoteRegister To Reply
  7. 10-28-2014, 04:57 PM #7
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populating Combo Box2 based on a selection made from Combo Box1
    By newqueen in forum Excel General
    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. Use activex combo box to filter (display rows that match the selection in the combo box
    By MAYWJ1 in forum Excel Programming / VBA / Macros
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1