Data Val list Excel 97 fire macro

rgarber50 · #1 10-09-2005, 08:22 AM

I have a column of cells which uses a data val list for entering data. The val list is dynamic and resides on the wks. When a user selects from the val list in a particular cell I would like a macro triggered which will place the date and time in the cell directly to the right (ie one column over, same row).

I need help in how to trigger the macro because Excel 97 events are not fired from data entered using a val list residing on the wks.

Thanks
Richard

#2 10-09-2005, 10:05 AM

You can use the Calculate event, as described here:

http://www.contextures.com/xlDataVal08.html#Change

rgarber50 wrote:
> I have a column of cells which uses a data val list for entering data.
> The val list is dynamic and resides on the wks. When a user selects
> from the val list in a particular cell I would like a macro triggered
> which will place the date and time in the cell directly to the right
> (ie one column over, same row).
>
> I need help in how to trigger the macro because Excel 97 events are not
> fired from data entered using a val list residing on the wks.
>
> Thanks
> Richard
>
>

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

#3 10-09-2005, 11:05 AM

Maybe you could put a button from the Forms toolbar right next to the cell with
data|validation.

Then have the user hit that.

rgarber50 wrote:
>
> I have a column of cells which uses a data val list for entering data.
> The val list is dynamic and resides on the wks. When a user selects
> from the val list in a particular cell I would like a macro triggered
> which will place the date and time in the cell directly to the right
> (ie one column over, same row).
>
> I need help in how to trigger the macro because Excel 97 events are not
> fired from data entered using a val list residing on the wks.
>
> Thanks
> Richard
>
> --
> rgarber50
> ------------------------------------------------------------------------
> rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
> View this thread: http://www.excelforum.com/showthread...hreadid=474583

--

Dave Peterson

rgarber50 · #4 10-09-2005, 11:13 AM

I've seen this, but it seems to require that the user hit a button to trigger the macro? Is there no way to make this event driven?

Richard

Quote:

Originally Posted by Debra Dalgleish

You can use the Calculate event, as described here:

http://www.contextures.com/xlDataVal08.html#Change

rgarber50 wrote:
> I have a column of cells which uses a data val list for entering data.
> The val list is dynamic and resides on the wks. When a user selects
> from the val list in a particular cell I would like a macro triggered
> which will place the date and time in the cell directly to the right
> (ie one column over, same row).
>
> I need help in how to trigger the macro because Excel 97 events are not
> fired from data entered using a val list residing on the wks.
>
> Thanks
> Richard
>
>

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

#5 10-09-2005, 01:05 PM

If you read the last paragraph in that section, it describes how to use
the Calculate event. There's no button required. Download the sample
file that's mentioned (ProductsList97Calc.zip), and you'll see how it works.

rgarber50 wrote:
> I've seen this, but it seems to require that the user hit a button to
> trigger the macro? Is there no way to make this event driven?
>
> Richard
>
>
>
>
>
> Debra Dalgleish Wrote:
>
>>You can use the Calculate event, as described here:
>>
>>http://www.contextures.com/xlDataVal08.html#Change
>>
>>rgarber50 wrote:
>>
>>>I have a column of cells which uses a data val list for entering
>>
>>data.
>>
>>>The val list is dynamic and resides on the wks. When a user selects
>>>from the val list in a particular cell I would like a macro
>>
>>triggered
>>
>>>which will place the date and time in the cell directly to the right
>>>(ie one column over, same row).
>>>
>>>I need help in how to trigger the macro because Excel 97 events are
>>
>>not
>>
>>>fired from data entered using a val list residing on the wks.
>>>
>>>Thanks
>>>Richard
>>>
>>>
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>
>
>

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Welcome to the Excel Forum

Forum Statistics