software

Is there a way to only have this function turn on after entering data in
column A/

Thanks for any help

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 gt; 1 Then Exit Sub

If Intersect(Target, Me.Range(quot;a:aquot;)) 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:
www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
www.cpearson.com/excel/events.htm

David McRitchie's site:
www.mvps.org/dmcritchie/excel/event.htm

ram wrote:
gt;
gt; Is there a way to only have this function turn on after entering data in
gt; column A/
gt;
gt; Thanks for any help

--

Dave Peterson

Thanks for the feedback Dave. I'll read up on this today.
quot;Dave Petersonquot; wrote:

gt; Maybe you could use an event macro.
gt;
gt; Right click on the worksheet tab that should have this behavior. Select view
gt; code and paste this into the code window:
gt;
gt; Option Explicit
gt; Private Sub Worksheet_Change(ByVal Target As Range)
gt;
gt; If Target.Cells.Count gt; 1 Then Exit Sub
gt;
gt; If Intersect(Target, Me.Range(quot;a:aquot;)) Is Nothing Then
gt; 'do nothing
gt; Else
gt; Target.Speak
gt; End If
gt; End Sub
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt; If you want to read more about these kinds of events:
gt;
gt; Chip Pearson's site:
gt; www.cpearson.com/excel/events.htm
gt;
gt; David McRitchie's site:
gt; www.mvps.org/dmcritchie/excel/event.htm
gt;
gt; ram wrote:
gt; gt;
gt; gt; Is there a way to only have this function turn on after entering data in
gt; gt; column A/
gt; gt;
gt; gt; Thanks for any help
gt;
gt; --
gt;
gt; Dave Peterson
gt;

****

url:www.ureader.com/msg/103424312.aspx

heyheyhey

url:www.ureader.com/msg/103424312.aspx