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

You can use the Calculate event, as described he

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

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

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 he

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


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=474583

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 he

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