No one liked the little ba_ _ard anyway.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steady-Stedis" wrote in message
...
I am not a proggrammer but what one would call a super user. Over the
years,
I have created over 50 spreadsheets for my accounting department using
macros
/ VBA coding. Many of these call up the office assistant to ask the user
a
question or for the user to select from a choice of options. A sample is
:

With Assistant.NewBalloon
.Heading = "Selecting Customer and Product"
.Text = "Select the Product Grouping you wish to view."
.CheckBoxes(1).Text = "Gasoline"
.CheckBoxes(2).Text = "Diesel"
.Button = msoButtonSetOkCancel

If .Show = msoBalloonButtonOK Then

If .CheckBoxes(1).Checked = True And .CheckBoxes(2).Checked =
False Then
Group = "Gasoline"
GoTo Line1:
ElseIf .CheckBoxes(1).Checked = False And
.CheckBoxes(2).Checked
= True Then
Group = "Diesel"
GoTo Line1:
Else
Set MyBalloon = Assistant.NewBalloon

With MyBalloon
.BalloonType = msoBalloonTypeBullets
.Heading = "Selecting Customer and Product"
.Text = "You Must select only one product grouping."
.Show

End With
GoTo Line0:

End If
End If
Set MyBalloon = Assistant.NewBalloon

With MyBalloon
.BalloonType = msoBalloonTypeBullets
.Heading = "Selecting Customer and Product"
.Text = "The process has been canceled."
.Show

End With

This coding does not seem to work in Excel 2007. The good news is that we
are slowly rolling out Excel 2007. The bad news is in about six months -
We
will no longer have access to Excel 2003. I can't believe that they
removed
this functionility completely.

Any thought on How I can keep / create something very close to what I
have?

Thanks in Advance!!