need some features in an excel form and some unexpected error to resolve

[AparnaWangu]

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

 

[Kyle123]

You can’t use the list property if you are populating the list box with rowsource

 

[AlphaFrog]

While entering data in the Hire date column it is displayed in dd-mm-yyyy format but when I select a entry from the listbox it is displayed in number format. Can u help me out.

Regards,

[color=darkblue]Private[/color] [color=darkblue]Sub[/color] LB_00_Click()
[color=green]'For i = 0 To 4[/color]
[color=green]'    Me("T_0" & i) = LB_00.Column(i)[/color]
[color=green]'Next[/color]
[B]T_00 = LB_00.Column(0)[/B]
[B]T_01 = LB_00.Column(1)[/B]
[B]ComboBox1.Value = LB_00.Column(2)[/B]
[B]T_03 = LB_00.Column(3)[/B]
[B]T_04 = Format(LB_00.Column(4), "dd-mm-yyyy")[/B]