Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sample code:
Sub test() With Assistant.NewBalloon .Heading = "Regional Sales Data" .Text = "Select the region(s) you want to print." For i = 1 To 3 .CheckBoxes(i).Text = "Region " & i Next .Button = msoButtonSetOkCancel If .Show = msoBalloonButtonOK Then dataPrinted = 0 For i = 1 To 3 If .CheckBoxes(i).Checked = True Then ' Code to print region data. dataPrinted = dataPrinted + 1 MsgBox "Region " & i & " data printed." End If Next If dataPrinted = 0 Then MsgBox "No data printed." End If End With End Sub regards, mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problems defining a global variable | Excel Programming | |||
Problems using a variable as a Table_Array in VLOOKUP | Excel Worksheet Functions | |||
Problems Defining Object Variable in For Each Loop | Excel Programming | |||
Problems usinga a variable in a worksheet function? | Excel Programming | |||
Problems usinga a variable in a worksheet function? | Excel Programming |