+ Reply to Thread
Results 1 to 5 of 5

Select Case Statement Alternative Large Number of Combinations

  1. #1
    Forum Contributor
    Join Date
    06-20-2011
    Location
    Auckland, NZ
    MS-Off Ver
    Excel 2013
    Posts
    165

    Select Case Statement Alternative Large Number of Combinations

    Hi Guys,

    I am using select case to do some web automation. I have large number of combinations here and select case statement won't help me. I have some combinations here->

    Please Login or Register  to view this content.
    I am using multiple data validation list. Attached is the excel file to that. Please find the attachment.

    I need an alternative that actually is easier and simple to use and replaces the large number of combinations. Thanks in advance guys.
    Attached Files Attached Files

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Select Case Statement Alternative Large Number of Combinations

    Hi, plasma33,

    just one question: will the order of selected items have influence on what macro shall be run or the order of macros which are needed? If not you could split the string and use the array to run the individual macros for each item and use a Select Case here.

    Ciao,
    Holger

    Don't forget to mark thread as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [ code ] Your code here [ /code ] (without the spaces inside the brackets)

  3. #3
    Forum Contributor
    Join Date
    06-20-2011
    Location
    Auckland, NZ
    MS-Off Ver
    Excel 2013
    Posts
    165

    Re: Select Case Statement Alternative Large Number of Combinations

    Thanks for your kind reply Holger. Can you please give me a small example?

    Cheers
    plasma33

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Select Case Statement Alternative Large Number of Combinations

    Hi, plasma,

    maybe have a go with this (needs causes for all items on the list and will only fill the direct window in the VBE):

    Please Login or Register  to view this content.
    HTH
    Holger

  5. #5
    Forum Contributor
    Join Date
    06-20-2011
    Location
    Auckland, NZ
    MS-Off Ver
    Excel 2013
    Posts
    165

    Re: Select Case Statement Alternative Large Number of Combinations

    Thanks for the code Holger. Worked perfectly. Thanks heaps.

    Cheers
    plasma33

+ 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