Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In menu, can able to Pass parameter using "OnAction" ?
Set MenuItem = NewMenu.Controls.Add _ (Type:=msoControlButton) With MenuItem .Caption = "Build Japan" .FaceId = 0 .OnAction = "Process_frm_GEN (\""JAP\"")" <--- This coding not works .BeginGroup = True '~~ Separators in menu End With Sub Process_frm_GEN(loSite As String) MsgBox loSite End Sub Also, it is possible pass parameters to form ? I want change Form Caption and some value. Sub Process_frm_SIN() frmProcess_SIN.Show End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Add-ins Menu Problems | Setting up and Configuration of Excel | |||
Problems with Edit Menu | Setting up and Configuration of Excel | |||
Toolbar Menu problems | Excel Programming | |||
Custom menu problems | Excel Programming | |||
Problems with Excel 2003 Help menu | Excel Discussion (Misc queries) |