Grid Control

[DebottamRoy]

Hello All,

I want to do my excel file comes in user form as in Grid view control.
Can anyone help me to do such activity?
I have tried but I faced the issue.
Below code, I have done.

Private Sub UserForm_Activate()
UserForm1.ListBox1.ColumnCount = 14
UserForm1.ListBox1.RowSource = Sheet1.Range("A1:N10")
End Sub

Anyone help me with this.

Thanks.

 

[AFPathfinder]

Try this and see if it works:

UserForm1.ListBox1.RowSource = "Sheet1!A1:N10"