+ Reply to Thread
Results 1 to 6 of 6

Right Click In specific Column to open menu and sub menu defined in Data Validation!

  1. #1
    Registered User
    Join Date
    06-22-2014
    Location
    Doha
    MS-Off Ver
    2013
    Posts
    87

    Right Click In specific Column to open menu and sub menu defined in Data Validation!

    Dears,

    Kindly assist me in creating a sheet in which If I click any cell in B column I'll get a menu with sub menu with values it will get from Data Validation or any other way around possible

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Right Click In specific Column to open menu and sub menu defined in Data Validation!

    What kind of assistance do you need? You haven't asked a question.

    Check out some info:
    https://msdn.microsoft.com/en-us/lib...ffice.14).aspx
    http://dmcritchie.mvps.org/excel/rightclick.htm
    Last edited by davesexcel; 02-17-2017 at 09:30 AM.

  3. #3
    Registered User
    Join Date
    06-22-2014
    Location
    Doha
    MS-Off Ver
    2013
    Posts
    87

    Re: Right Click In specific Column to open menu and sub menu defined in Data Validation!

    Dear,

    Kindly help me create a sheet in which If I click any cell in B column I'll get a menu with sub menu with values it will get from Data Validation or any other way around possible

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Right Click In specific Column to open menu and sub menu defined in Data Validation!

    Repeating your first post is not asking a question.

    What do you need assistance with? Right clicking on column B, adding a menu to the right click menu, getting a validation list ?

    Kindly assist us in supplying what you have tried and showing what you need assistance with.

  5. #5
    Registered User
    Join Date
    06-22-2014
    Location
    Doha
    MS-Off Ver
    2013
    Posts
    87

    Re: Right Click In specific Column to open menu and sub menu defined in Data Validation!

    Dear,

    I don't know how to create such a list in a cell right click event. So need help on that

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Right Click In specific Column to open menu and sub menu defined in Data Validation!

    The links I sent you would be a good start, also you can search for more examples yourself.

+ 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. Add divider lines and sub-menu to right-click menu
    By ChrisXcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 07:48 PM
  2. add button to right-click menu in External Data range
    By dlh in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-21-2010, 07:39 PM
  3. Replies: 3
    Last Post: 12-10-2009, 09:30 PM
  4. Replies: 1
    Last Post: 07-26-2006, 06:30 PM
  5. [SOLVED] why can't i click on the data menu when using excel in IE
    By andrewirby in forum Excel General
    Replies: 0
    Last Post: 07-25-2006, 12:10 PM
  6. Add menu item to right-click menu
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2006, 05:35 AM
  7. Create Dropdown menu without using the Validation on the Data Menu
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-13-2006, 03:47 PM
  8. Change the right click menu on cells with imported data?
    By Beth Trainer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-08-2005, 02:45 PM

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