samedi 15 mai 2021

Excel VBA: How to populate a combobox with cell values from each row if conditions are met

I'm trying to populate a combobox with the values in column B of each row, but only if the following conditions are met:

  1. The cell in column B is not empty/has a value.
  2. The cell in column H is empty/has no value.

The code needs to only consider values after row 3 (because those are table headings) and it needs to be able to adjust to changes in the worksheet.

If anyone has some tips I'd really appreciate it! I've been struggling with this for days.

I can post my code if it would help, but it's a mess from all the different things I've tried.

Aucun commentaire:

Enregistrer un commentaire