ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Office Assistant Question (https://www.excelbanter.com/excel-programming/378407-office-assistant-question.html)

Les Stout[_2_]

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 ***

Bob Phillips

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 ***




Les Stout[_2_]

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 ***

Les Stout[_2_]

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 ***

michdenis

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 ***



Les Stout[_2_]

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

Les Stout

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

Jim Cone

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 ***


All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com