Results 1 to 5 of 5

Macro code to show message depends on selection from Combobox/List

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2012
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Macro code to show message depends on selection from Combobox/List

    Hi,

    I have attached the excel sheet, Sheet "A" contains CUG & CUG Verification, Sheet "B" contains Database.
    Example:
    If user selects "US" in "A2", depending on that Look into perticular user's CUG number in Sheet B, if the cell contains number show message as "CUG Found" in B2
    If user selects "UK" in "A2", depending on that Look into perticular user's CUG number in Sheet B, if the cell contains number show message as "CUG Found" in B2.
    If user selects "US & UK" in "A2", depending on that Look into perticular user's CUG number in Sheet B, if the cell contains both number show message as "CUG Found" in B2
    Otherwise "No CUG Found".

    Thanks
    Attached Files Attached Files
    Last edited by snn3; 09-10-2012 at 01:38 PM.

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