Problem clicking subitems in listview to open a userform

Hello, i came here to ask you guys if someone could help me in a problem i have, im quite new with excel vba and im having some issues in one thing, i have a listview with subitems (wich are located in column1 of excel) and i what i want is to click any subitem in that listview and what that does is opening a userform (which is a
telephone bill) with some data i will input later, but the problem is that i have no clue how to do it and i did search a lot :/


Thanks in advance

THere is no 'native' way in VBA to determine which sub-item was clicked.

so ure saying theres no way i can make the program this way? if there isnt there's other way?

I have no idea about your program... You asked " what i want is to click any subitem in that listview" and I answered that. Sorry I can't be more specific.

so basicly what i have is a 2 columns in excel sheet 1, one with like 800 phone numbers records (not all diferent) and in the other column the price of the calls,messages, etc that the numbers made, i made a listview that removes the duplicated numbers and open another with the numbers but only 1 of each, and what i want is to click in a number in that listview and open a userform(that is the phone bill) saying how much calls and messages they did and the total money they spent

Why are you using a listview rather than a listbox?

like i said im new at this i dont know much, i started working with this 2 weeks ago so im newbie :s

Well you must have a reason for using a list view, you've got to go to some lengths to use it. It's not a standard control

yes i searched it and taked like 2 days to finally get listview working , because i was trying to do this with listbox and i got no results :s

nice forum..