K
Kulin
Question :
=======
Exact syntax required when clicking/selecting AddItem 1 , I can invoke the
following Sub ShowExpenses()
Worksheets("Data").Select
End Sub
, on selecting AddItem 2, I can invoke the
Sub ShowSales()
Worksheets("Facility").Select
End Sub
and on selecting AddItem 3, I can invoke the following
Sub ShowPurchases()
Worksheets("Segment").Select
End Sub
Bye the way , I am little bit novice for VBA-EXCELL.
My entire procedure start from here :
========================
Sub CreateNewToolBar()
'the next two lines are only required during development
On Error Resume Next
CommandBars("Accounts").Delete
Dim NewMenuBar As CommandBar
Dim NewButton As CommandBarButton
Set NewMenuBar = CommandBars.Add("Accounts")
Set NewButton = NewMenuBar.Controls.Add(msoControlButton,
CommandBars("View").Controls("Normal").ID)
NewButton.Caption = "&Normal"
NewButton.Style = msoButtonIconAndCaptionBelow
Set NewButton = NewMenuBar.Controls.Add(msoControlButton,
CommandBars("View").Controls("Page Break Preview").ID)
NewButton.Caption = "&Preview"
NewButton.Style = msoButtonIconAndCaption
Set NewButton = NewMenuBar.Controls.Add(msoControlButton)
NewButton.Caption = "&Data"
NewButton.Style = msoButtonCaption
NewButton.OnAction = "ShowExpenses"
Dim NewComboboxButton As CommandBarComboBox
Set NewComboboxButton = NewMenuBar.Controls.Add(msoControlComboBox)
NewComboboxButton.Caption = "&Segment"
NewComboboxButton.OnAction = "ShowPurchases"
With CommandBars("Accounts").Controls(4)
.AddItem "Item 1", 1
.AddItem "Item 2", 2
.AddItem "Item 3", 3
.DropDownLines = 3
.ListIndex = 1
End With
Set NewButton = NewMenuBar.Controls.Add(msoControlButton)
NewButton.Caption = "&Facility"
NewButton.Style = msoButtonCaption
NewButton.OnAction = "ShowSales"
Set NewButton = NewMenuBar.Controls.Add(msoControlButton)
NewButton.Caption = "&E&xit"
NewButton.OnAction = "RestoreExcelMenuBar"
NewButton.Style = msoButtonCaption
Worksheets("AccountsSheet").Select
NewMenuBar.Visible = True
End Sub
Sub ShowExpenses()
Worksheets("Data").Select
End Sub
Sub ShowPurchases()
Worksheets("Segment").Select
End Sub
Sub ShowSales()
Worksheets("Facility").Select
End Sub
Sub RestoreExcelMenuBar()
CommandBars("Accounts").Delete
Application.Quit
End Sub
=======
Exact syntax required when clicking/selecting AddItem 1 , I can invoke the
following Sub ShowExpenses()
Worksheets("Data").Select
End Sub
, on selecting AddItem 2, I can invoke the
Sub ShowSales()
Worksheets("Facility").Select
End Sub
and on selecting AddItem 3, I can invoke the following
Sub ShowPurchases()
Worksheets("Segment").Select
End Sub
Bye the way , I am little bit novice for VBA-EXCELL.
My entire procedure start from here :
========================
Sub CreateNewToolBar()
'the next two lines are only required during development
On Error Resume Next
CommandBars("Accounts").Delete
Dim NewMenuBar As CommandBar
Dim NewButton As CommandBarButton
Set NewMenuBar = CommandBars.Add("Accounts")
Set NewButton = NewMenuBar.Controls.Add(msoControlButton,
CommandBars("View").Controls("Normal").ID)
NewButton.Caption = "&Normal"
NewButton.Style = msoButtonIconAndCaptionBelow
Set NewButton = NewMenuBar.Controls.Add(msoControlButton,
CommandBars("View").Controls("Page Break Preview").ID)
NewButton.Caption = "&Preview"
NewButton.Style = msoButtonIconAndCaption
Set NewButton = NewMenuBar.Controls.Add(msoControlButton)
NewButton.Caption = "&Data"
NewButton.Style = msoButtonCaption
NewButton.OnAction = "ShowExpenses"
Dim NewComboboxButton As CommandBarComboBox
Set NewComboboxButton = NewMenuBar.Controls.Add(msoControlComboBox)
NewComboboxButton.Caption = "&Segment"
NewComboboxButton.OnAction = "ShowPurchases"
With CommandBars("Accounts").Controls(4)
.AddItem "Item 1", 1
.AddItem "Item 2", 2
.AddItem "Item 3", 3
.DropDownLines = 3
.ListIndex = 1
End With
Set NewButton = NewMenuBar.Controls.Add(msoControlButton)
NewButton.Caption = "&Facility"
NewButton.Style = msoButtonCaption
NewButton.OnAction = "ShowSales"
Set NewButton = NewMenuBar.Controls.Add(msoControlButton)
NewButton.Caption = "&E&xit"
NewButton.OnAction = "RestoreExcelMenuBar"
NewButton.Style = msoButtonCaption
Worksheets("AccountsSheet").Select
NewMenuBar.Visible = True
End Sub
Sub ShowExpenses()
Worksheets("Data").Select
End Sub
Sub ShowPurchases()
Worksheets("Segment").Select
End Sub
Sub ShowSales()
Worksheets("Facility").Select
End Sub
Sub RestoreExcelMenuBar()
CommandBars("Accounts").Delete
Application.Quit
End Sub