Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rgarber50
 
Posts: n/a
Default Data Val list Excel 97 fire macro


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

  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #4   Report Post  
rgarber50
 
Posts: n/a
Default


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

  #5   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Update Excel Data List for Drop Down use LynnS Excel Discussion (Misc queries) 2 June 10th 05 11:35 PM
Pull Current Month's Data Out of List - Repost Karl Burrows Excel Discussion (Misc queries) 4 May 3rd 05 01:06 AM
how do I make a word typed in a cell go to a specific cell in anot Lmatarazzo Excel Discussion (Misc queries) 3 April 21st 05 04:29 AM
Excel, Data Validation List Ken H Excel Discussion (Misc queries) 1 March 1st 05 06:28 PM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"