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

Hi all, is it possible to use the office assistant as a "Fancy textbox"
?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,726
Default Office Assistant Question

Les,

I can't say I really understand what you are asking, but most people that I
know turn the office assistant off, it is just too annoying.

Would a custom userform do what you want?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Les Stout" wrote in message
...
Hi all, is it possible to use the office assistant as a "Fancy textbox"
?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Office Assistant Question

I think it must be the jovial festive season.. Was just wondering if one
could use the wizard like a pop up message with the animations...and
upon clicking ok that it just hide's again..

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Office Assistant Question

I think it must be the jovial festive season.. Was just wondering if one
could use the wizard like a pop up message with the animations...and
upon clicking ok that it just hide's again... I do not want to use it
for help at all, just call it like you would a text box for info...

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 135
Default Office Assistant Question

Try This :

'----------------------------
Sub YesNo()
Assistant.Sounds = True
Assistant.On = True
With Assistant.NewBalloon
..Animation = 112
..BalloonType = 1
..Button = 4
..Heading = "Save" & vbLf & "Your modifications ?"
..Icon = 6
..Mode = 0
If .Show = -3 Then MsgBox "Ok for jovial festive season!", 64
End With
Assistant.On = False
End Sub
'----------------------------




"Les Stout" a écrit dans le message de news:
...
I think it must be the jovial festive season.. Was just wondering if one
could use the wizard like a pop up message with the animations...and
upon clicking ok that it just hide's again... I do not want to use it
for help at all, just call it like you would a text box for info...

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Office Assistant Question

Thanks for the help MichDenis, will give it a bash..

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Office Assistant Question

Be aware, if the Office Assistant is not installed the code will not work.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Les Stout" wrote in message ...
Thanks for the help MichDenis, will give it a bash..
Les Stout
*** Sent via Developersdex http://www.developersdex.com ***
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
Help with Office Assistant VBA Mojo Excel Discussion (Misc queries) 1 July 20th 09 09:53 PM
Office Assistant clanbull Excel Discussion (Misc queries) 2 September 16th 08 08:48 AM
office assistant ceemo Excel Discussion (Misc queries) 1 March 1st 06 11:30 PM
how do i get the office assistant to install in office 2003? MONASTERYRN Excel Discussion (Misc queries) 1 December 15th 05 09:15 PM
Office Assistant Sunflower Excel Discussion (Misc queries) 0 March 30th 05 06:51 AM


All times are GMT +1. The time now is 11:57 PM.

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

About Us

"It's about Microsoft Excel"