Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Sub sb(lb As MSForms.ListBox, bDel As Boolean) msg = MsgBox("is it continue?", vbYesNo, "") If msg = vbNo Then Exit Sub For i = 1 To lb.ListCount - 1 If lb.Selected(i - 1) Then Call sbxx(lb.List(i - 1), bDel) Next Application.CutCopyMode = False End Sub Private Sub cmdDelDes_Click() msg = MsgBox("is it continue?", vbYesNo, "") If msg = vbNo Then Exit Sub xx=1 End Sub i want to make the sub routine. 2 lines of the upper code make function. namely, Sub sb(lb As MSForms.ListBox, bDel As Boolean) call sby For i = 1 To lb.ListCount - 1 If lb.Selected(i - 1) Then Call sbxx(lb.List(i - 1), bDel) Next Application.CutCopyMode = False End Sub Private Sub cmdDelDes_Click() call sby xx=1 End Sub sub sby ~~~~~~ end sub *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Primary and Secondary tech locator | Excel Discussion (Misc queries) | |||
Excel Charts in Science & Tech. | Charts and Charting in Excel | |||
Mainframe Tech Blog | Excel Discussion (Misc queries) | |||
TECH SUPPORT NUMBERS | New Users to Excel | |||
High Tech Question ? | Excel Programming |