Excel: Display combobox as listview subitem

Hello all,

I am running into some problems trying to implement this:

I need to have a combobox for user selection as a listview subitem (not the listitem) to enable selection by the user.

The Listview_MouseUp event only provides x and y coordinates for the click event, but I am stuck trying to figure out how to place a combo box over the relevant subitem (i.e., finding out its exact coordinates).

I have googled this item a lot and it seems to be possible using subclassing (which I do not know much about), but the best example I've found so far deals with coloring lines, not adding combo boxes:
http://www.excelforum.com/excel-prog...ored-line.html

Has anyone had to tackle this before or knows how I could solve it?
Any help is greatly appreciated.

Also, if anyone has a suggestion for a different control than listview, I'd be happy to look into that (would have to be free, though).

Has anyone ever done this before?

I can rephrase the problem now:
I need a guide for subclassing a VBA listview on a user form to add row background colors and combo-boxes.

Should I start a new thread with that?

Still hoping someone out there knows or can point me to a solution.

Cheers!

How much data is there and which features of the listview are you actually using?

Thanks for replying, Kyle123.
There will be two listviews in report view, 1 with 3 columns, the other with 10-ish.
The rows will differ from 10-20 up to as much as several hundred (in extreme cases).

The functions I need are:
* row back color
* combo boxes as/in sub items
* (would also be great make certain subitems editable (i.e. column-wise, e.g. every subitem in col 10 can take a user comment)
* and of course, read back the user changes in combos and subitems...

I haven't had to provide such GUI functionality in Excel/VBA yet, so any hint on how to implement this is greatly appreciated.

Cheers

Have a look here http://www.vbforums.com/showthread.p...ide-a-Listview at the attachment that BruceG has uploaded. It's for VB6, but essentially identical for VBA, it's using the standard listview and making it editable by positioning a textbox/combobox.

A simpler solution would be to have the edit boxes/dropdowns separate in the form and just populate them with data from the listview when clicked

Kyle123,

thank you very much for the pointer. I've tried to import BruceG's file in my VBA project, but couldn't import all.
I can import the modules into the project, though, but not the forms/project (vbp/vbw)...
Any chance you can help me with this step, too?
Sorry and thanks a lot

You can't import them directly, but you can open them in notepad to see what's going on

You should be able to copy and paste most of the code then just re-create the relevant controls on the form

tbh though I'd want a good reason not to go with the alternative of having the edit boxes not in the listview - it's much more simple

The reason not to have them separately is the requestor for this form. Wvery click is 1 too many...
I'll try to work with the sample file.
One last question: Regarding coloring individual list view rows... that seems not to be possible without subclassing, right?