IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2013-10-01T15:01:53Z by bsosale
SystemAdmin
SystemAdmin
1061 Posts

Pinned topic VBA and showing listbox as grid

‏2013-01-17T18:30:22Z |
I would like to use VBA to pull up a dialog to display a listbox in a grided format to show a list of objects and their properties much like the attached image. Is there a way I can reuse this SA control in my own VBA dialog form?
Updated on 2013-01-30T14:56:13Z at 2013-01-30T14:56:13Z by SystemAdmin
  • TerryMoriarty
    TerryMoriarty
    126 Posts

    Re: VBA and showing listbox as grid

    ‏2013-01-23T01:43:25Z  
    Yes, it's possible.

    I have a search macro that was developed for me that is better than anything that is delivered with SA out of the box. It incorporated the type of listbox you are looking for.

    Unfortunately, the macro is completely undocumented. I'm in the process of doing that. So, while I know the name of the list control widget, I haven't isolated all of its supporting subroutines yet.

    Once I figure it out, I'll be happy to let you know what code you need.

    I've attached a copy of the search encyclpedia form for you.

    Terry
  • SystemAdmin
    SystemAdmin
    1061 Posts

    Re: VBA and showing listbox as grid

    ‏2013-01-30T14:56:13Z  
    Yes, it's possible.

    I have a search macro that was developed for me that is better than anything that is delivered with SA out of the box. It incorporated the type of listbox you are looking for.

    Unfortunately, the macro is completely undocumented. I'm in the process of doing that. So, while I know the name of the list control widget, I haven't isolated all of its supporting subroutines yet.

    Once I figure it out, I'll be happy to let you know what code you need.

    I've attached a copy of the search encyclpedia form for you.

    Terry
    Yeahup, that looks like an elegant use of the list box. Thanks!
  • bsosale
    bsosale
    22 Posts

    Re: VBA and showing listbox as grid

    ‏2013-10-01T15:01:53Z  
    Yeahup, that looks like an elegant use of the list box. Thanks!

    Hi Terry,

      Greetings.

      If it is possible to share the code for the above search GUI?. I am trying to use it to export selected data from an Ency.

      Thanks

      Bala