.TextBox1.Value = Sheet42.Cells(.ComboBox1.ListIndex + 19, 18)

Instead of the textbox referencing 1 worksheet, I would like it to reference anyworksheet that my combobox has selected.