Topic
3 replies Latest Post - ‏2013-10-01T15:01:53Z by bsosale
SystemAdmin
SystemAdmin
1061 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: VBA and showing listbox as grid

    ‏2013-01-23T01:43:25Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: VBA and showing listbox as grid

      ‏2013-01-30T14:56:13Z  in response to TerryMoriarty
      Yeahup, that looks like an elegant use of the list box. Thanks!
      • bsosale
        bsosale
        22 Posts
        ACCEPTED ANSWER

        Re: VBA and showing listbox as grid

        ‏2013-10-01T15:01:53Z  in response to SystemAdmin

        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