Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change sheet value
Hi again! Apparently selecting a date from a data validation list does not trigger a Private Sub Worksheet_Change(ByVal Target As Excel.Range). How can I accomplish this? I would like for the code to run when the user selects the new date from the data validation list. I could just put a button for the user to click after changing the date but I wanted to ask anyway. Thanks!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=567100 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change sheet value
This problem was fixed in xl2k (xl97 still suffers from the problem).
How about putting a button near the cell with data|validation that will invoke the macro. Or dump the data|validation completely and use either a dropdown from the Forms toolbar or a combobox from the Control toolbox toolbar. Brian Matlack wrote: Hi again! Apparently selecting a date from a data validation list does not trigger a Private Sub Worksheet_Change(ByVal Target As Excel.Range). How can I accomplish this? I would like for the code to run when the user selects the new date from the data validation list. I could just put a button for the user to click after changing the date but I wanted to ask anyway. Thanks!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=567100 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change sheet value
Thanks Dave!! I have a workbook that I create and keep examples in and this code doe not work in it. However! When I put the code into my users workbook it works fine.???? I must have a problem in the Example workbook. There are 30 or 40 cod examples in it and maybe one of them sets a criterion that fowls-u this one. I'll keep looking! Thanks again for your time and help!! -- Brian Matlac ----------------------------------------------------------------------- Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350 View this thread: http://www.excelforum.com/showthread.php?threadid=56710 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change sheet value
Are all the workbooks running the same version of excel--if yes, what version?
And when you're snooping, make sure you look to see that you enableevents after you've disabled them. Brian Matlack wrote: Thanks Dave!! I have a workbook that I create and keep examples in and this code does not work in it. However! When I put the code into my users workbook it works fine.???? I must have a problem in the Example workbook. There are 30 or 40 code examples in it and maybe one of them sets a criterion that fowls-up this one. I'll keep looking! Thanks again for your time and help!!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=567100 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - Auto - Sheet Name change ? expiry | Excel Discussion (Misc queries) | |||
Auto fill Certain data from Sheet 1 to Sheet 2 | Excel Worksheet Functions | |||
Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
Auto Change sheet value | Excel Programming | |||
Sheet-to-sheet auto-entries of text | Excel Worksheet Functions |