NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2013-10-01T15:01:53Z by bsosale
Pinned topic VBA and showing listbox as grid
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
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 2700024KJP126 PostsACCEPTED ANSWER
Re: VBA and showing listbox as grid2013-01-23T01:43:25Z in response to SystemAdminYes, 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.