AparnaWangu
New Member
- Joined
- Aug 22, 2016
- Messages
- 11
Hi Team,
I have created an onboarding form for employees and there is a worksheet where the data is getting stored.
The problem is now there is a runtime error coming in a listbox click function where all the records are displayed from the datasheet so in case of any modification user dont have to go to datasheet again and again.
I am attaching the file for reference with some dummy data.Please check that why that error comes.
Secondly I want the the headers to be displyed for all the columns in the list box which is not happening currently.
I am new to VBA so please please please help me.
Private Sub LB_00_Click()
For i = 0 To 4
Me("T_0" & i) = LB_00.Column(i) The error comes as runtime error and could not find the specified object
Next
Regards,
APS
I have created an onboarding form for employees and there is a worksheet where the data is getting stored.
The problem is now there is a runtime error coming in a listbox click function where all the records are displayed from the datasheet so in case of any modification user dont have to go to datasheet again and again.
I am attaching the file for reference with some dummy data.Please check that why that error comes.
Secondly I want the the headers to be displyed for all the columns in the list box which is not happening currently.
I am new to VBA so please please please help me.
Private Sub LB_00_Click()
For i = 0 To 4
Me("T_0" & i) = LB_00.Column(i) The error comes as runtime error and could not find the specified object
Next
Regards,
APS