+ Reply to Thread
Results 1 to 6 of 6

Double clicking the results in Listview to bring up another userform to show the result

  1. #1
    Registered User
    Join Date
    08-25-2021
    Location
    Kuching, Malaysia
    MS-Off Ver
    2016 32bits
    Posts
    30

    Post Double clicking the results in Listview to bring up another userform to show the result

    Hi everyone,

    I am very new to VBA. I have managed to create a listview to show search results for my database.

    I am stuck with one last thing I need the most. I hope someone can help me out.

    I created a listview for my search results and what I am trying to do is from my listview results I want to be able to double click a row of data (results) to bring up the specific data in another userform so the results can be shown in a more organized look. Results showing in textboxes.

    Attached is my excel file
    Attached Files Attached Files
    Last edited by Cyril Beki; 08-26-2021 at 04:48 AM.

  2. #2
    Registered User
    Join Date
    06-02-2018
    Location
    Italy
    MS-Off Ver
    2013-2019
    Posts
    31

    Re: Double clicking the results in Listview to bring up another userform to show the resul

    File is locked with password.

  3. #3
    Registered User
    Join Date
    08-25-2021
    Location
    Kuching, Malaysia
    MS-Off Ver
    2016 32bits
    Posts
    30

    Re: Double clicking the results in Listview to bring up another userform to show the resul

    i already update the excel file without password

  4. #4
    Registered User
    Join Date
    08-25-2021
    Location
    Kuching, Malaysia
    MS-Off Ver
    2016 32bits
    Posts
    30

    Re: Double clicking the results in Listview to bring up another userform to show the resul

    Quote Originally Posted by gibra View Post
    File is locked with password.
    i already update the excel file without password

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Double clicking the results in Listview to bring up another userform to show the resul

    Try the code below - looping will not work as your last item is out of sequence.
    Why not use a listbox instead of listview - far easier to reference.

    Please Login or Register  to view this content.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  6. #6
    Registered User
    Join Date
    08-25-2021
    Location
    Kuching, Malaysia
    MS-Off Ver
    2016 32bits
    Posts
    30

    Re: Double clicking the results in Listview to bring up another userform to show the resul

    Quote Originally Posted by torachan View Post
    Try the code below - looping will not work as your last item is out of sequence.
    Why not use a listbox instead of listview - far easier to reference.

    Please Login or Register  to view this content.
    Wow, thank you for the code !! i've test it and it run perfectly. Really appreciate your effort and time in answering my question. God bless you.!!

+ 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. open specific userform by double clicking in a row from a listview
    By lem1222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2019, 07:21 AM
  2. Show cells from pivot table without double clicking
    By EggsCell in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-04-2016, 07:10 AM
  3. Problem clicking subitems in listview to open a userform
    By marcoexcel16 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-12-2016, 05:14 AM
  4. Replies: 15
    Last Post: 02-07-2012, 11:39 AM
  5. 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
  6. Double Clicking Fill Handle yields no result
    By STarloff in forum Excel General
    Replies: 4
    Last Post: 05-28-2010, 09:06 AM
  7. Double Clicking on link w/i workbook does't bring me to souce.
    By tfranc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2006, 08:20 AM

Tags for this Thread

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