Hello EveryOne!
I have got a UserForm which pulls data from Excel sheet and show it on UserForm.
UserForm1 has TextBox's as follow:
ComboBox1.......Select Year
ComboBox2.......Select Batch
TextBoxYear........Showing Year
TextBoxBatch...... Showing Batch number
TextBox1 ........... Showing Month 1 data
TextBox2.............Showing Month 2 data
TextBox3...............Showing Month 3 data
.
.
.
.
TextBox12...........Showing Month 12 data
It shows data correctly in UserForm1 for TextBoxYear, TextBoxBatch and TextBox1 to TextBox7 but when it reaches TextBox8 (Month 8) it give error "Could not get Column property, Invalid argument"
and it does not show data in TextBox8 (Month 8) .......to..........TextBox12 (Month 12) and give error in code from
".TextBox8 = ListBox1.Column(10)"
I have attached workbook with userform.
Please Help
Kind Regards
z-eighty2
I have got a UserForm which pulls data from Excel sheet and show it on UserForm.
UserForm1 has TextBox's as follow:
ComboBox1.......Select Year
ComboBox2.......Select Batch
TextBoxYear........Showing Year
TextBoxBatch...... Showing Batch number
TextBox1 ........... Showing Month 1 data
TextBox2.............Showing Month 2 data
TextBox3...............Showing Month 3 data
.
.
.
.
TextBox12...........Showing Month 12 data
It shows data correctly in UserForm1 for TextBoxYear, TextBoxBatch and TextBox1 to TextBox7 but when it reaches TextBox8 (Month 8) it give error "Could not get Column property, Invalid argument"
and it does not show data in TextBox8 (Month 8) .......to..........TextBox12 (Month 12) and give error in code from
".TextBox8 = ListBox1.Column(10)"
I have attached workbook with userform.
Please Help
Kind Regards
z-eighty2