VBA for Excel

[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

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/PopUpMenuDemo.zip
It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm

Demonstrates how to create and implement a popup menu.
The workbook covers two areas:
* Creating a popup menu
* Using the Right_Click event

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[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 ...

 

[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)

 

[Tom Ogilvy]

Look at Data->Validation and choose the List Option.