+ Reply to Thread
Results 1 to 3 of 3

Need Excel Macro to compare Values of two column based on Combo box selection in form

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    3

    Need Excel Macro to compare Values of two column based on Combo box selection in form

    Dear All,

    Am having a user form1 and have combo box and button in it

    Am selecting a value "Feb" from Combo box, then i have some columns having data's below "jan" and "feb" header

    I need a macro that should check after i select Feb from combo box
    {

    If (get values under jan and return 'true' if values present else 'false') &&
    (get values for Feb and return 'true if present else 'false')

    }

    True or false i need based on which i need to update one column at the end with this value.

    Kindly help ! . thank you

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Need Excel Macro to compare Values of two column based on Combo box selection in form

    Hi,

    Posting a sample file, will help us to understand your needs.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Registered User
    Join Date
    12-05-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need Excel Macro to compare Values of two column based on Combo box selection in form

    Hi Xlbiznes,

    Thank you for your response. Kindly find the file attached

    and refer the 'userform1' for details.

    Whenever user selected the month from the userform1 then the macro should check "sheet4" for that month and previous month and give the result.

    Thank you
    Attached Files Attached Files

+ 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. [SOLVED] Can a Userform Combo Box selection run a macro based on the selections filtered criteria?
    By jmotuk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-09-2013, 02:23 PM
  2. [SOLVED] Combo Box2 selections available based on Combo box 1 selection
    By wishn4fishn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2013, 08:13 PM
  3. combo box input range based on the other combo box selection
    By hedayet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2013, 02:27 AM
  4. Run a macro based on a Combo Box Selection
    By DBHaley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2011, 03:32 AM
  5. Excel - populating data (checkboxes) based on combo box selection
    By gkang116 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2011, 06:50 PM

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