+ Reply to Thread
Results 1 to 4 of 4

How to open a userform just by clicking on a cell

  1. #1
    Registered User
    Join Date
    10-11-2006
    Posts
    5

    How to open a userform just by clicking on a cell

    Hello,

    I'm one of the "new ones" again with a lot of questions!!

    Ok here we go!


    I would like to be able to open a UserForm just by clicking (or double clicking) on a cell... Is there any action that enables this?

    Thank you for answering?

    eph!e

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    See the attached file.

    To do it, open excel, open VB editor (alt + f11), double click (in project window) on the sheet where you want to select cell
    in the left combo (where is displayed general) choose worksheet and in the right combo choose selection change

    here use the code:
    if target.address (false,false) = "B2" (the letter must be upper case)
    userform1.show
    end if

    Regards.
    Antonio

  3. #3
    Registered User
    Join Date
    10-11-2006
    Posts
    5

    Thank you Antonio

    Thank you Antonio,

    It works !! Cool

    ephie

  4. #4
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    I'm sorry but I missed the attachment.

    i'm happy to knoew you resolved.

    Regards.
    Antonio
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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