Hi Guys, I'm sorry for asking because I'm sure the answer is obvious, but many, many Google searches have not provided me a solution. I'm trying to get a userform to send data to specific cells based on what tab is selected. I have a combobox and a textbox on the tabs. I was the data to go into column 1-2 if tabstrip1, 3-4 if tabstrip2, etc. So normally my code would look like -
Cells(emptyRow, 1).Value = ComboBox1.Value
Cells(emptyRow, 2).Value = TextBox1.Value
But I can't figure out how to make it read the tab value since they are all called combobox1 & textbox1. I know I can do this all with pages, but I like the uniformity of tabstrips. I tried tabstrip1.combobox1.value but that gave me an error. A point in the right direction would be greatly appreciated.
Cells(emptyRow, 1).Value = ComboBox1.Value
Cells(emptyRow, 2).Value = TextBox1.Value
But I can't figure out how to make it read the tab value since they are all called combobox1 & textbox1. I know I can do this all with pages, but I like the uniformity of tabstrips. I tried tabstrip1.combobox1.value but that gave me an error. A point in the right direction would be greatly appreciated.