Listview For 64 Bit Excel Version

Se interessa ancora, Ok si può fare con Excel 2016 64 Bit.

I'm not sure what you mean by 2D listobject in ListBox.

Can you upload sample workbook demonstrating/illustrating your need?

Note: Don't forget to set .ColumnCount property of ListBox to appropriate number. Otherwise, you'll only see first column in the box.

Ex:

Please Login or Register  to view this content.

Use labels to show the headers
see attached

So are you looking for headers to be displayed or the topmost entry visible in the listbox when scrolled?????

Or labels if you don't need horizontal scrolling - you just make them the same width as your column widths: see https://www.excelforum.com/tips-and-...e-listbox.html

I somehow missed about have the posts in this thread haha so nigelog probably did

@NeedForExcel

As others have stated, there is no way to include header in listbox without using rowsource. If you are able to... use row source to fill listbox from worksheet range.
If that's not feasible (often isn't for code efficiency etc)... then you can add labels, or just add single row lisbox with same dimension on top of your lisbox to serve as a header.
Do note, there isn't any event available for scrolling on listbox, so you'll either have to manually adjust or fit all columns into listbox.

Is there really no way to get listviews to work on win10 box? What about upgrading to full visual basic? Does that at least give access to a comparable control?

Nope, not that’s accessible in a vba userform

What about the Listgrid control listed about halfway down the page at https://jkp-ads.com/Articles/treeview.asp
?

It's not free but I have no idea how much it costs.

What about running a 32 bit virtual machine? Google search shows that it's possible to create a 32 bit virtual machine on a 64 bit machine but it's not clear to me if this would actually work. And I have zero experience with virtual machines.

If it means extra software and $$, that's ok.

Ummmmmm...

Am I confused or has this been fixed? Seems I can run dialogs with listviews in them on my windows 10 box. Files I couldn't use 6 months ago suddenly work fine.

???

Originally Posted by CK76

Probably bit confused. Win 10 64 bit is different from Excel 32 bit / 64 bit.

Excel/Office 64 bit, will not be able to run Listview. While Win 10 64 bit with Excel 32 bit install will be able to.

Has this always been the case? I'm pretty sure that we've always had 32 bit excel but listviews didn't work a few months back but now suddenly they work. Two different win 10 boxes.

Originally Posted by Cyclops

Has this always been the case? I'm pretty sure that we've always had 32 bit excel but listviews didn't work a few months back but now suddenly they work. Two different win 10 boxes.

As it turns out, we were running 32 office on 64 bit machines. At install, listview and some other features didn't work. After forcing updates and rebooting a few times, they work fine. Was reminded recently when another computer was upgraded to win10 and many files stopped working. Forced update and everything was fine.