Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SubMenu .action argument
I have created a customized menu with submenus which I want to have run
the sub procedure "EnterInvoice" that passes a variable "VendorName" from the .OnAction part of the With SubMenu CommandButton to the macro. I have declared the argument in the sub as: Sub EnterInvoice(ByVal VendorName) but can't figure out how to do it. I've tried different versions of the following but can not get the syntax to work. Set SubMenuItem = MenuItem.Controls.Add(Type:=msoControlButton) With SubMenuItem .Caption = "Co&mmissary Order" .OnAction = "EnterInvoice"(Commissary) End With Ideas? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Function Argument | Excel Worksheet Functions | |||
Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) | |||
How do I set up an argument which asks for multiple criteria | Excel Discussion (Misc queries) | |||
text argument in vlook up which has a "" | Excel Worksheet Functions | |||
read in Vlookup an argument that has quotations(") | Excel Discussion (Misc queries) |