User Form Facing Compile Error and Automation Error

Dear xlnitwit,

Thanks for your mail. Since i am in a learning phase, i am not able to identify what i have selected as reference for this project. But after searching from web, i went to tool icon and select reference and remove "Microsoft Office Common Control 2.0 SPA" and then now its working for few of them. But the rest of the person, they are facing the automation error.

No, some of them they are using Microsoft Professional 2013 and 2016 also. How can i fix this issue? Please guide me.

Regards

Dear Mr. Xlnitwit,

I am extremely sorry for the delay response. Debug shows "SVForm.Show"

Regards

Private Sub Workbook_Open()
SVForm.Show
End Sub

Dear sir,

The yellow color highlighted on "SVForm.Show" code, which i have given in "This Workbook"

Regards

Dear Mr. Xlnitwit,

If i click debug first time, it will highlight "SVForm.Show" and if i keep on pressing F8, the yellow color highlighted line moving to the below given code. Even after if i press F8, the yellow color highlighted line moving only between "Me.cbfacilityname.AddItem ws.Cells(i, "B").Value and next i".

Private Sub UserForm_Initialize()

Dim i As Long, LastRow As Long, ws As Worksheet
Set ws = Worksheets("FacilityDetails")
LastRow = ws.Range("B" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
Me.cbfacilityname.AddItem ws.Cells(i, "B").Value
Next i

Kindly do the needful.

Sir,

If i press F5, again the message box shows, "Run-time Error '-2146232576 (80131700)' Automation Error" and i click debug, it will highlight "SVForm.Show" only. even after keep on pressing F5, yellow color highlights on "SVForm.Show" only.

Regards

Sir,

I just followed your guidance and instruction and found the error. I have enclosed the screenshot of that.

Regards

Sir,

How could i fix this issue? please guide me.. Really breaking my head...

Regards

Dear sir,

Thanks for your patience and guiding me. I found other way to fix this issue. I downloaded Microsoft .NET Framework 2.0 SP2 (which automatically also installed 3.5) at the same time, and the following code now works.

Regards