+ Reply to Thread
Results 1 to 9 of 9

Merging 2 VBA Codes

  1. #1
    Registered User
    Join Date
    11-02-2010
    Location
    Los Angeles
    MS-Off Ver
    Ms Excel 2010
    Posts
    6

    Merging 2 VBA Codes

    Hi Guys,

    I'm new to VBA coding, so please bare with me

    I want to implement multiple selections within several drop down list, after googling and searching here and there i managed to find the following coding lines which work great in any given column:

    Please Login or Register  to view this content.
    Now, The issue is that I want the multiple selection to apply to at least 2 Columns, I've tried several combinations wit If/End if/Else & Else If, and after cleaning up I seem to disable the loop effect,

    Can anyway help?

    kindest regards!

    Cruz
    Last edited by arlu1201; 04-23-2013 at 11:37 AM. Reason: Use code tags in future.

  2. #2
    Registered User
    Join Date
    11-02-2010
    Location
    Los Angeles
    MS-Off Ver
    Ms Excel 2010
    Posts
    6

    Re: Merging 2 VBA Codes

    Hi Guys, Can anyone help?

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Merging 2 VBA Codes

    I can try to look at it later, but I'm not sure what you are trying to do. Could you elaborate in words and post a sample workbook? You'll tend to get more responses if you take both actions.

    Good luck.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  4. #4
    Registered User
    Join Date
    11-02-2010
    Location
    Los Angeles
    MS-Off Ver
    Ms Excel 2010
    Posts
    6

    Re: Merging 2 VBA Codes

    Thanks abousetta,

    the following Code:

    Please Login or Register  to view this content.
    enables me to apply mutliple selections out of a Drop Down List but only in Column '9', now what I need is to apply the macro to Column 8 & 9 at once, I tried to replicate the code inside the code using IF and END IF but somehow it always ends up applying the macro only to one Column,

    thank you for your help
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-02-2010
    Location
    Los Angeles
    MS-Off Ver
    Ms Excel 2010
    Posts
    6

    Re: Merging 2 VBA Codes

    Can someone help please?

  6. #6
    Registered User
    Join Date
    11-02-2010
    Location
    Los Angeles
    MS-Off Ver
    Ms Excel 2010
    Posts
    6

    Re: Merging 2 VBA Codes

    +1
    Can anyway assist me?

  7. #7
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Merging 2 VBA Codes

    Hi,

    I can't test at the moment, but replace this line

    Please Login or Register  to view this content.
    with

    Please Login or Register  to view this content.
    abousetta

  8. #8
    Registered User
    Join Date
    11-02-2010
    Location
    Los Angeles
    MS-Off Ver
    Ms Excel 2010
    Posts
    6

    Re: Merging 2 VBA Codes

    Work Great, Thanks!

  9. #9
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Merging 2 VBA Codes

    Thanks for the feedback.

    Good luck.

    abousetta

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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