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

[debson]

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

[TMS]

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

[debson]

sorry please find attached, I currently am using vlookup but need to do this in vba
NYK_SOA_0412.xlsm

[TMS]

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

[debson]

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?

[debson]

Just wondering if anyone can help with this at all.

[TMS]

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

Please Login or Register  to view this content.

Regards, TMS

[debson]

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

[TMS]

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

[debson]

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

[TMS]

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

[debson]

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

[TMS]

You're welcome.