Results 1 to 1 of 1

VBA Code for CTRL + Right Click to Bring Up User Form

Threaded View

nathandavies9 VBA Code for CTRL + Right... 09-13-2017, 09:55 AM
  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    Castelford
    MS-Off Ver
    2013
    Posts
    89

    VBA Code for CTRL + Right Click to Bring Up User Form

    Hi All,
    I'm After some help writing some code to complete the following.

    So if you press CTRL + Right Click on any cell in Column A it will bring up a user form which has 3 buttons. "Open Folder" "Open Latest Drawings" "Cancel". I'm wanting each button to go to a location on our server based on which button is pressed.

    1. To go to project folder it will have to look at SERVER\Company (Column C) \Project No (Column A) & Project Name (Column B). this will then open that folder location
    3. Unload User form.

    Would anyone be able to help or have done something similar that i could maybe try and edit? I have included my workbook with the two columns highlighted and the user form already created for your assistance.


    Cheers
    ND
    Attached Files Attached Files
    Last edited by nathandavies9; 09-14-2017 at 01:08 PM. Reason: Wrong details

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Double click on cell > Open User form > insert value
    By amein in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2016, 05:24 AM
  2. [SOLVED] Saving excel macro based on commandbutton1 click (user form)
    By S1n1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2015, 03:15 PM
  3. Insert n number of rows from a user form click event
    By vn900 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2011, 08:37 PM
  4. User form and list - click events
    By vn900 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2011, 12:02 AM
  5. Why is the scrollbar in a user form, by the first click on a button, scrolling?
    By Excel-Master in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-21-2010, 11:01 PM
  6. double click to bring up form
    By simpo067 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2009, 10:35 AM
  7. [SOLVED] Detecting Ctrl-Tabs in User Form input fields?
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2005, 10:25 PM

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