Hi,
I have created a userform in one of my excel and want to save the information of the label into the excel cells. In my userform i have multiple options Text Box, Labels & List Box. i can update the information of Text Box and List Box, but when i try to update for Labels, i am getting an error. kindly assist.
Eg:
For Text Box : Sheet2.Cells(RowCount, 1).Value = UserForm1.TextBox1.Value (Working Fine)
For List Box : Sheet2.Cells(RowCount, 7).Value = UserForm1.ComboBox5.Value (Working Fine)
For Labels : Sheet2.Cells(RowCount, 8).Value = UserForm1.Label15.Text (Not Working)