.Cells (RowIndex, Column Using Header Name)

  • Hello, I am very VBA experience deficient and I've tried searching for some help but am stuck.

    I'm making a user form, where there are ComboBoxes 1-10 (cmbProduct1, etc.) and TextBoxes 1-10 (txtProduct1Qty,etc.)

    The user fills out the form and the quantities are stored in a "database sheet" organized by products as column headers. There are 40 Products, and 10 entrys on the form. So I need the 10 entrys to find their way to the right columns.

    I need help matching the .Cells(RowIndex, ColumnIndex) based on the option selected in the combobox. I want to use a Header name, instead of a number here:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!