Results 1 to 3 of 3

Thread: Cell content dependant on contents of two Dropdowns (ComboBox)

  1. May 17th, 2006, 05:55 AM #1
    Firestart
    Firestart is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2005
    Posts
    69

    Cell content dependant on contents of two Dropdowns (ComboBox)

    Hi I need to compare the contents of 2 dropdowns and then populate a field with some text in Excel.

    e.g. if dropdown 1 = x, dropdown 2= y cell G7 = P
    if dropdown 1 = x, dropdown 2= z cell G7 = c
    if dropdown 1 = y, dropdown 2= y cell G7 = q


    and so on.

    Any ideas?
    Last edited by Firestart; May 19th, 2006 at 06:52 AM. Reason: Rename title
    Reply With Quote Reply With Quote
  2. May 17th, 2006, 09:35 AM #2
    New2vba
    New2vba is offline
    Lively Member New2vba's Avatar
    Join Date
    Sep 2005
    Location
    UK
    Posts
    95

    Re: Cell content dependant on contents of two Dropdowns (Excel)

    Are these control dropdowns (combobox) or are they lists generated through the data validation menu?
    "Those things we must learn to do, we must learn by doing" (or hope somebody else will take pity and help out )
    Reply With Quote Reply With Quote
  3. May 19th, 2006, 04:44 AM #3
    Firestart
    Firestart is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2005
    Posts
    69

    Re: Cell content dependant on contents of two Dropdowns (Excel)

    Combobox.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width