Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Balloon Assistant

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comment balloon on a chart Anthony Blackburn Charts and Charting in Excel 1 May 13th 08 04:11 AM
how do I turn office assistant on in exel cannot find balloon or ? maggie Excel Discussion (Misc queries) 1 April 15th 07 09:36 AM
New Balloon - VBA JohnM New Users to Excel 3 September 24th 06 06:56 PM
How do I add a balloon message to a locked cell kden01 Excel Discussion (Misc queries) 2 January 28th 05 06:49 PM
Programatically Displaying Office Assistant Balloon John[_57_] Excel Programming 1 September 16th 03 10:57 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"