User Form combo box populates the wrong cell in worksheet

[Grilleman]

Hello -

A sample workbook with my VBA code is attached.

First, I am trying to populate a worksheet via a User Form. Columns A & B may contain data between rows 6 and 20 though in my attached example I only have data across row 6. My User Form contains a combo box with up to five valid values (codes 1,2, 3, 4 & 5). In my example, the valid value selected from the combo box needs to populate cell C6. However, because text is present in cells A6 & B6, the valid value I select from the combo box fills cell C7 instead of C6. Were I to add values in columns A & B across row 7, the valid value selected from the combo box fills cell C8.

Thanks for any help!

Grilleman

[pjwhitfield]

You were finding the last row with data in and then going to the one below.

Please Login or Register  to view this content.

makes it populate C6