Hi All,
I am trying to Populate a textbox on a vb form with a value that is x number of columns to the right of combobox value, currently I have it displaying the value of the combobox...
scoresheet.TextBox1.Text = scoresheet.ComboBox1.Value
so I need it to find the combobox value on the scoresheet worksheet and use the value that is 1 column to the right of that value
once that is done I need to populate the next textbox with the value 2 columns to the right and so on, I assume this will just be a case of writing the same code with a different column number?
thanks in advance
I am trying to Populate a textbox on a vb form with a value that is x number of columns to the right of combobox value, currently I have it displaying the value of the combobox...
scoresheet.TextBox1.Text = scoresheet.ComboBox1.Value
so I need it to find the combobox value on the scoresheet worksheet and use the value that is 1 column to the right of that value
once that is done I need to populate the next textbox with the value 2 columns to the right and so on, I assume this will just be a case of writing the same code with a different column number?
thanks in advance