+ Reply to Thread
Results 1 to 13 of 13

Find Row from Combo Box List Drop Down, auto populate Other Cells

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Find Row from Combo Box List Drop Down, auto populate Other Cells

    Hi I have used Contextures Data Validation combo box... the combo box on sheet 1 looks up named list values on sheet 2 I need to autopopulate other cells on sheet 1 with data from row selected.... I have tried listIndex to find row selected to auto populate other cells using VBA... I have searched everywhere but not found anything in forums that have helped.....Code is below

    Please Login or Register  to view this content.
    Looking forward to any help

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,939

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    It would be easier to investigate your problem with a sample workbook with some typical data and the code and combo boxes in context.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    sorry please find attached, I currently am using vlookup but need to do this in vba
    NYK_SOA_0412.xlsm
    Last edited by debson; 05-21-2012 at 08:59 AM. Reason: forgot extra info

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,939

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    Thanks for the workbook. I'm a bit lost about what the process is. What do you do with the combobox? And what do you want to be able to do?

    Can you step me through what you do and what happens ... and what code is executed and what it does.

    Couldn't see VLOOKUPs though there were a couple of INDEX/MATCHes

    Thanks

  5. #5
    Registered User
    Join Date
    05-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    Again sorry writing things late at night brain doesn't work... sorry yes I was using vlookup then changed to index match... basically where there is index match I want to replace these with vba to cal data. In row C all cells are set to data validation and when you double click in a cell it brings up a comb box to select data on the second sheet, I would like to get the row number when user selects it then when I have this row number use this to autopopulate the cells that currently have index match in them, I tried to use list index but this didn't work it just seemed t stop the code from working at all?

  6. #6
    Registered User
    Join Date
    05-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    Just wondering if anyone can help with this at all.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,939

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    I'm not sure if this is what you are looking for:

    Please Login or Register  to view this content.

    Regards, TMS

  8. #8
    Registered User
    Join Date
    05-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    Thanks TMS.. I will give this a go .. I didn't think of just putting in formulas to cells.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,939

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    Well, you don't have to. But, as you've gone to all the trouble of working them out, it seems a shame to waste it.

    The way I convert a formula into VBA is to record a macro. First select the cell with the formula. Then start the macro recorder. Press F2 to go into Edit mode and press Enter to (re-)commit the formula. Stop the macro recorder.

    You will now have a macro that puts the formula into the Active Cell. Just edit the cell reference as required.

    Regards, TMS

  10. #10
    Registered User
    Join Date
    05-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    I did try but for some reason it doesn't fire when I change the cell in C.... will try again tonight at home..

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,939

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    Might be that an event handler was stopped or crashed leaving event handling turned off.

    Try, in the immediate window:

    Please Login or Register  to view this content.

    Regards, TMS

  12. #12
    Registered User
    Join Date
    05-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    OMG didn't even think of that, all good now thankyou soooo much works like a dream

  13. #13
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,939

    Re: Find Row from Combo Box List Drop Down, auto populate Other Cells

    You're welcome.

+ 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