Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all, is it possible to use the office assistant as a "Fancy textbox"
? Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the help MichDenis, will give it a bash..
Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Office Assistant VBA | Excel Discussion (Misc queries) | |||
Office Assistant | Excel Discussion (Misc queries) | |||
office assistant | Excel Discussion (Misc queries) | |||
how do i get the office assistant to install in office 2003? | Excel Discussion (Misc queries) | |||
Office Assistant | Excel Discussion (Misc queries) |