Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office Assistant went away w/2007 - Now What?
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office Assistant went away w/2007 - Now What?
Not really help because I've no experience of 2007 but if Microsoft have
killed off that annoying pest then that's the first good reason I've heard of for upgrading to to it. Mike "Steady-Stedis" wrote: 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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office Assistant went away w/2007 - Now What?
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office Assistant went away w/2007 - Now What?
use a form or inputbox, as the other replies echo my sentiments.
-- Gary "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!! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office Assistant went away w/2007 - Now What?
You can use a built-in Message box or built-in Inputbox or
create a custom UserForm. Rough examples follow for Msgbox and Input box... '-- MsgBox "Gasoline This Time?", vbQuestion + vbYesNoCancel, "Blame Stedis" '-- Dim strResponse As String strResponse = InputBox("Enter G for Gasoline or D for Diesel.", "Blame the Other Guy", "Gasoline") -- Jim Cone Portland, Oregon USA "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!! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office Assistant went away w/2007 - Now What?
Excellent opportunity to expand your programming skills. The demise of
MACRO4.0 froced me to learn VBA. You can do things with drawing objects, word art and the things other responders have mentioned. It can be a fun learning experience, or a pain in the posterior, depending on the individual attitude. Good riddance to the Office Assistant. "Steady-Stedis" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How I add an office assistant | Excel Discussion (Misc queries) | |||
Help with Office Assistant VBA | Excel Discussion (Misc queries) | |||
how do i get the office assistant to install in office 2003? | Excel Discussion (Misc queries) | |||
Office Assistant ... | Excel Programming | |||
Office Assistant | Excel Discussion (Misc queries) |