Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help on the Assistant Balloon
Hello,
In my visual basic macro, I create a balloon (Assistant) that presently has two buttons; the first button asks the user to select a page number, and the second button returns the user back to the main excel program. I need help to add an inputbox space to my Balloon. I want the user to type in the page number in the inputbox space and then press the first button. See my balloon code below. Can someone please help me. Thanks much. Christy Sub BalloonPage1() Selection.HomeKey Unit:=wdStory Set bln = Assistant.NewBalloon With bln .Heading = "Select Topic" .Labels(1).Text = "Select Page Number of Topic first and then press this button. " .Labels(2).Text = "Return to DietBook" .BalloonType = msoBalloonTypeButtons .Button = msoButtonSetNone .Mode = msoModeModeless .Callback = "GotoPage1" .Show End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comment balloon on a chart | Charts and Charting in Excel | |||
how do I turn office assistant on in exel cannot find balloon or ? | Excel Discussion (Misc queries) | |||
New Balloon - VBA | New Users to Excel | |||
Balloon Assistant | Excel Programming | |||
Programatically Displaying Office Assistant Balloon | Excel Programming |