+ Reply to Thread
Results 1 to 10 of 10

Problem clicking subitems in listview to open a userform

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    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

  2. #2
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    243

    Re: Problem clicking subitems in listview to open a userform

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

  3. #3
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    Re: Problem clicking subitems in listview to open a userform

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

  4. #4
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    243

    Re: Problem clicking subitems in listview to open a userform

    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.

  5. #5
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    Re: Problem clicking subitems in listview to open a userform

    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

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,149

    Re: Problem clicking subitems in listview to open a userform

    Why are you using a listview rather than a listbox?

  7. #7
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    Re: Problem clicking subitems in listview to open a userform

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

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,149

    Re: Problem clicking subitems in listview to open a userform

    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

  9. #9
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    Re: Problem clicking subitems in listview to open a userform

    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

  10. #10
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    Re: Problem clicking subitems in listview to open a userform

    nice forum..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] HELP! can't add listview activex in userform :(
    By radian89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2015, 09:05 AM
  2. Call userform 1 from userform 2 allowing to open workbook 1 clicking button 1
    By FMontana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2015, 02:29 AM
  3. [SOLVED] Problem with Listview display in userform
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2014, 08:10 AM
  4. [SOLVED] add listView to userform programatically
    By contaminated in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 05:11 PM
  5. [SOLVED] Excel 2007 Google maps by clicking a listview item
    By ioncila in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2012, 12:41 PM
  6. Double clicking the results in Listview to bring up another userform
    By vbanew in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-22-2011, 04:29 AM
  7. How to open a userform just by clicking on a cell
    By ephie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2006, 09:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1