Re: Macro invocation after data enrtry

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 18:57:36 +0200

Hi
no problem as you can restrict this macro. e.g. try the following:
Private Sub Worksheet_Change(ByVal Target As Range)
if intersect (target,me.range("A1:A100")) is nothing then exit sub
'run your code
End Sub

your code is only invoked in this example if cell A1:A100 are changed 

--
Regards
Frank Kabel
Frankfurt, Germany
josh wrote:
> Thank you Frank. I thought about your solution, but I'm afraid my
> application involves to many other work*** changes where I don't
> want to invoke the macro.
>
> Josh Page
>
> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> news:uzCZfcuTEHA.808@tk2msftngp13.phx.gbl...
>> Hi
>> you could use an event procedure. e.g. the worksheet_change event
for
>> this. See:
>> http://www.cpearson.com/excel/events.htm
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>>
>> josh wrote:
>>> I have an Excel application which involves typing data into one or
>>> more cells and then clicking a button which invokes a macro. The
>>> person who does this data entry chronically forgets to press enter
>>> after typing the data and instead clicks the macro button to no
>>> avail.  Is there any way that a single key stoke or mouse click
>>> could both signal the end of typing and invoke the macro?
Quantcast