+ Reply to Thread
Results 1 to 3 of 3

Intersect method to open userform when clicking on row selector

  1. #1
    Registered User
    Join Date
    12-13-2010
    Location
    melbourne australia
    MS-Off Ver
    Excel 2016
    Posts
    58

    Intersect method to open userform when clicking on row selector

    Hi Guys,

    I am currently using the intersect method to open a userform by clicking on a cell in a given range . Code below.

    Is it possible to amend this code to open a form on row selection?

    Please Login or Register  to view this content.
    Thanks in advance.
    V
    Last edited by virencm; 02-04-2022 at 10:58 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,629

    Re: Intersect method to open userform when clicking on row selector

    If Target.Row = X Then
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-13-2010
    Location
    melbourne australia
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: Intersect method to open userform when clicking on row selector

    thank 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. how to open prepared before macro sheet by clicking commandbutton on userform
    By ertanatalar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2020, 06:23 PM
  2. 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
  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. 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
  5. Intersect method not working or?
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2011, 02:52 PM
  6. 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
  7. Intersect Method
    By Arne Hegefors in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2006, 07:20 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