Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Nate = Eeeeeeeeevil
![devil.gif](/board/proxy.php?image=http%3A%2F%2Fhomepage.a5.com%2F%7Ekristy%2Fmisc%2Fsmilies%2Fdevil.gif&hash=71025c49fa8080e2b6f7ef39f54c2d30)
On 2002-12-05 14:09, Von Pookie wrote:
Nate = Eeeeeeeeevil![]()
On 2002-12-10 16:03, entity789 wrote:
I'd love to see that. Any way to get the assistant to say something unique? or respond to specific data entry?
On 2002-12-10 16:41, NateO wrote:
On 2002-12-10 16:03, entity789 wrote:
I'd love to see that. Any way to get the assistant to say something unique? or respond to specific data entry?
Well here's a moderated version of this (for Jack) as an example of controlling our favourite little bugger: Clippy:<pre>
Sub Helper()
Dim rspns As Integer
Set myBalloon = Assistant.NewBalloon
With myBalloon
.BalloonType = msoBalloonTypeButtons
.Button = msoButtonSetNone
.Text = "It looks like you're working on a spreadsheet." _
& Application.Rept(Chr(13), 2) & "Would you like me to:"
.Labels(1).Text = "******** it up for you"
.Labels(2).Text = "Just f*** off and leave you alone"
rspns = .Show
End With
Select Case rspns
Case 1: Cells.Clear
End Select
End Sub</pre>
You could very easily refer to ranges, etc...
_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by nateo on 2002-12-10 20:16