VBA for Excel

K

kjmagnuson

Is there a way to do a right mouse click (or some other action) o
certain cells that will bring up a list of choosen items that can b
used in that particular cell
 
A

Andy Wiggins

J

Jim May

Native to excel -- In a column where you have already enter a unique item -
you can on the next cell right-click select "Pick-from-List" and there
select a previously entered value that you wish to reenter into the current
cell ...
 
B

Bob Phillips

Standard Excel has such a right-click menu,

If you want to add to it, the commandbar name is Cell. Here is some example
code

Set oCB = Application.CommandBars("Cell")

With oCB.Controls
With .Add(temporary:=True)
.BeginGroup = True
.Caption = "A right-click option"
.OnAction = "myMacro"
End With End With



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top