Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Play Back speech function
Is there a way to only have this function turn on after entering data in
column A/ Thanks for any help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Play Back speech function
Maybe you could use an event macro.
Right click on the worksheet tab that should have this behavior. Select view code and paste this into the code window: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("a:a")) Is Nothing Then 'do nothing Else Target.Speak End If End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm If you want to read more about these kinds of events: Chip Pearson's site: http://www.cpearson.com/excel/events.htm David McRitchie's site: http://www.mvps.org/dmcritchie/excel/event.htm ram wrote: Is there a way to only have this function turn on after entering data in column A/ Thanks for any help -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Play Back speech function
Thanks for the feedback Dave. I'll read up on this today.
"Dave Peterson" wrote: Maybe you could use an event macro. Right click on the worksheet tab that should have this behavior. Select view code and paste this into the code window: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("a:a")) Is Nothing Then 'do nothing Else Target.Speak End If End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm If you want to read more about these kinds of events: Chip Pearson's site: http://www.cpearson.com/excel/events.htm David McRitchie's site: http://www.mvps.org/dmcritchie/excel/event.htm ram wrote: Is there a way to only have this function turn on after entering data in column A/ Thanks for any help -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Play Back speech function
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Play Back speech function
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
creating function (vba) with range arguments | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
SUMIF function | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |