Worksheet_BeforeRightClick

Jan 22, 2010

I am using a right click event with code that allows me to populate a name list. (“mylist”) that is used for a Data Validation drop down. This code below works great but I need for it to be used with other Target cells and there assigned name list that are within the same worksheet. When I try to repeat the code and change the range, I get an error. Do I need to assign a reference to cells selection for code or?

Here are the other target cells with there assigned name list ....

View 14 Replies


ADVERTISEMENT

Worksheet_SelectionChange Vs. Worksheet_BeforeRightClick

Nov 21, 2003

Worksheet_SelectionChange(ByVal Target As Range)

from executiing each time i like to execute

Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved