ListView control with 64 bits version of FlexPro

SupportCommunity Automation and VBA ListView control with 64 bits version of FlexPro

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Autor
    Beiträge
  • #12861
    Anonym
    Inaktiv

    Hello,

    I use a ListView control in many UserForms. This control comes with Office 2007 (mscomctl.ocx).
    This control is very helpfull when some information must be show in tables/cells, with column header (resizing, reordering), grid lines, different text color in each cells, checkboxes for items, …
    I can’t replace this control with a ListBox, because a ListBox control doesn’t provide many features I need.
    Unfortunately, Microsoft doesnt’t provide an equivalent ActiveX for 64 bits version of Windows.

    I’m looking if its possible to make calls to Windows API functions, in order to create an fill the ListView.

    I also use ListView controls in C/C++ programs : I tried to translate some C/C++ code into VBA, using several this Windows API functions :
    – FindWindow : to retreive the HWND handle of my userform
    – CreateWindowEx : to create a ListView
    – SendMessage : to change some extend styles, to insert columns, to insert items and subitems

    A just have two “little” problems :
    – the ListView controls seems frozen : for example, scroll bars or selecting items doesn’t work.
    – I don’t know how to get events from the ListView.

    Is It possible to change the userform’s WindowProc by a to SetwindoLongPtr(hwndUserForm, GWL_WNDPROC, AddressOf MyWndProc)
    to treat the ListView notifications messages and call the original userform’s WindowProc for the other messages ?

    Or have you (or somebody else) another suggestion for replacing mscomctl.ocx ?

    Thanks in advance.

    #8521
    Anonym
    Inaktiv

    Hello,

    I use a ListView control in many UserForms. This control comes with Office 2007 (mscomctl.ocx).
    This control is very helpfull when some information must be show in tables/cells, with column header (resizing, reordering), grid lines, different text color in each cells, checkboxes for items, …
    I can’t replace this control with a ListBox, because a ListBox control doesn’t provide many features I need.
    Unfortunately, Microsoft doesnt’t provide an equivalent ActiveX for 64 bits version of Windows.

    I’m looking if its possible to make calls to Windows API functions, in order to create an fill the ListView.

    I also use ListView controls in C/C++ programs : I tried to translate some C/C++ code into VBA, using several this Windows API functions :
    – FindWindow : to retreive the HWND handle of my userform
    – CreateWindowEx : to create a ListView
    – SendMessage : to change some extend styles, to insert columns, to insert items and subitems

    A just have two “little” problems :
    – the ListView controls seems frozen : for example, scroll bars or selecting items doesn’t work.
    – I don’t know how to get events from the ListView.

    Is It possible to change the userform’s WindowProc by a to SetwindoLongPtr(hwndUserForm, GWL_WNDPROC, AddressOf MyWndProc)
    to treat the ListView notifications messages and call the original userform’s WindowProc for the other messages ?

    Or have you (or somebody else) another suggestion for replacing mscomctl.ocx ?

    Thanks in advance.

    #9366
    Bernhard KantzBernhard Kantz
    Moderator

    We regret that general questions on VBA programming are beyond the scope of this forum.

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.