Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i have a code which adds sheet names to combo box
Dim ctrl As CommandBarControl Dim wks Set ctrl = Application.CommandBars("myNavigator") _ .FindControl(Tag:="__wksnames__") ctrl.Clear For Each wks In ActiveWorkbook.Sheets 'If wks.Visible = xlSheetVisible Then ctrl.AddItem wks.Name 'End If Next wks End Sub i need a code which deletes the selected sheet from combo box... the following code is throwing me an error ......... Set ctrl = .Controls.Add(Type:=msoControlButton, temporary:=True) With ctrl .Style = msoButtonCaption .Caption = "Delete Sheets" .OnAction = "'" & ThisWorkbook.Name & "'!DeleteSheets" End With End With Sub DeleteSheets() Dim myWksName As String Dim wks With Application.CommandBars.ActionControl If .ListIndex = 0 Then MsgBox "Please select an existing sheet" Exit Sub Else .Delete .List(.ListIndex) End If End With Set wks = Nothing On Error Resume Next On Error GoTo 0 If wks Is Nothing Then Call RefreshTheSheets MsgBox "Please try again" Else wks.Select End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CommandBarComboBox : AddItem - procedure to attach routine. | Excel Programming | |||
commandbarCombobox problem | Excel Programming | |||
how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions | |||
Remove .xls from selected files | Excel Programming | |||
CommandBarComboBox.AddItem - String Length Limit? | Excel Programming |