An Ideal option required instead of Listbox. Coud you suggest

[SamDsouza]

Hello

What is the ideal object on Windows(App...Vb.net Frame...) Userform instead of Listbox with MultipleColumn and without columncount

As Columncount is not member of List box in the userform.

What i would like is to have a replica of listbox of Multiple Columns with a check box as VBA userform had Listbox.Liststyle = frmListStyleoption and in VBA i could add max columns as 10 with below some Critical Properties of Listbox

Listbox.Multiselect = fmMultiSelect

Listbox.SpecialEffect = frmSpecialeffectSunken
Listbox.TextAlign = fmTextAlignLeft
Listbox.MatchEntry = fmMatchEntryFirstLetter
Listbox.Columncount = 10
Listbox.ColumnWidths = "80,55,80,80,100,80,50,35,55"

With the above listbox it had CheckBox for selection inside. Then Seperate Label.Caption which acted as header and Text inside were placed in such a way that text placed above the columns exactly. So Represented Column Headername.
With the above listbox had 2 checkoxes seperately in userform for Selection of All items and Unselection of all items

With the above scenario of Listbox of VBA What would be more Fantastic option me to incorporate the right object in the userform.
Below Data in another worksheet. And how may columns could be added in that object and formatting of those columns.

Col A      Col B        Col C        Col D      uptlil Col J
Fruit       Apple          52        240/Kg   ......
Fruit       Kiwi            24        180/Kg    .....
Fruit       Pineaapple   36        220/Kg   .....

Textbox1.Text ="Fruit" then Listbox will display the above data with Full selection with Ticked checkbox

Thanks
SamD
23 Thread 4: 892229

[.paul.]

The ListView control can be used as a multi-column ListBox. Set the View property to Details.
Google it for an example...

[SamDsouza]

.Paul.
Thanks for the suggestion let me give it a try and revert back.

The ListView control can be used as a multi-column ListBox. Set the View property to Details.
Google it for an example...

Thanks
SamD
24 Thread 4: 892229

[kareninstructor]

If you need some code samples check out the following GitHub repository and article. Code samples use SQL-Server to populate ListView controls yet any database can be used or no database.

[SamDsouza]

Karen

If you need some code samples check out the following GitHub repository and article. Code samples use SQL-Server to populate ListView controls yet any database can be used or no database.

Thank you so much for the reference. Yes, will love to go through it and revert back. Mostly queries from my side shall be for MS-Excel at present.
FYI have gone through your solutions on few of the forums

Thanks
SamD
29 Thread 4: 892229

[.paul.]

The ListView is not the best choice for displaying from a database. The ListView is a display control, but the DataGridView is designed to be used with databases. There are plenty of properties you can change to alter the appearance of the DataGridView as much or as little as you choose. It can also be used as a read only control, which the ListView would also be.

[SamDsouza]

Paul

The ListView is not the best choice for displaying from a database. The ListView is a display control, but the DataGridView is designed to be used with databases. There are plenty of properties you can change to alter the appearance of the DataGridView as much or as little as you choose. It can also be used as a read only control, which the ListView would also be.

Hmmmm Ok. Seems Very Intresting

As per your reply#2. I started using ListView.

Let me know for Viewing an Excel Sheet AsIs will Datagrid be ok ? if not then which is the object to view Excel Sheet. on the userform
Although there are commands to Open and view the xlsx files.

Thanks
SamD
31 Thread 4: 892229

[.paul.]

You can query an Excel Worksheet with SQL, then bind it to the DataGridView

[SamDsouza]

Paul

You can query an Excel Worksheet with SQL, then bind it to the DataGridView

Unfortunately no knowledge of SQL. May be leave it here.

Nevertheless let the oppurtunity come will see at that time.

SamD
33 Thread 4: 892229

[ChrisE]

Paul

Unfortunately no knowledge of SQL. May be leave it here.

Nevertheless let the oppurtunity come will see at that time.

SamD
33 Thread 4: 892229

I gave you a sample with OLEDB .. here ..

https://www.vbforums.com/showthread....=1#post5524714

Post#8 you just need to try,use it