View Single Post
  #28   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Get a color name from any RGB combination?

"GS" wrote in message
If the listview only contains a single column it has the same
appearance and in effect functionality as a treeview that has
multiple root nodes but no branches. Only reason to use a listview
in such a case is for it's capability to add icons to items, as
can do with a treeview.


Ah! So it's the other way around; using listview as a treeview! I
don't think the icon factor makes this worth the trouble for
displaying data in a VBA userform.


No, use a treeview to resemble a listview, albeit for the limited
purpose I described (and can't use aX/ocx controls)

Please have a look at my listbox-based example when I'm done with
it. Though Charlotte's usage only includes 4 fields of data, it can
handle as many fields as a listbox max ColumnCount. This should be
more than ample for a database solution that's flat-table text file
based, and uses standard VB file I/O functions. IMO, that's as
simple as it gets for working with smaller amounts of data. If it
does grow large it can be easily 'dumped' into a SQLite db file and
worked with via ADODB.


Can you point me to where it is (or again if as I assume it's linked
somewhere in this long thread!)


I'll be posting a download link (in this thread) for Charlotte *when
I'm done with it*! (As I said, I couldn't find my original project so
I'm redoing it from scratch)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion