If there is anything in a cell in Column D, then I want the function to automatically put a period beside the cell in column E. If there is nothing in the cell in Column D, then I don't want there to have anything happen.
I want this to happen automatically in the worksheet... so I don't have to run a macro everytime. Thx
Last edited by Xx7; 02-18-2011 at 11:17 PM.
Place this macro in the SHEET MODULE so it is active all the time. It will watch for activity in column D. If any cell in column D is changed, it place a period in column E. If the change CLEARS a cell in column D, the column E period would be removed, too.
Please Login or Register to view this content.
Last edited by JBeaucaire; 02-16-2011 at 12:19 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Jerry,
It seems to give me a run-time error anytime I enter info in columns other than D. Any way around this?
Thanks!
My bad, correction added above.
Beautiful... works like a charm
Dear Jerry,
Would it be better if we use intersect so that when the data gets huge, this will only run macro on the specific cell updated.
Pls advice as I am also exploring.Please Login or Register to view this content.
Cheers,
CL
My macro in post #2 only operates on the cell(s) just changed. My design is set to watch all the cells you change, even if you do more than one cell at one time, and operate on the ones that are in column D. Did you notice the Intersect() reference already in my macro?
Your macro utilized Activecell references which I would not do.
Hi Jerry,
I had the impression that the "For" loop command will run thru all cells. Thanks for pointing out the occassion that user may mass update cells using copy-paste actions.
Cheers,
CL
The FOR/NEXT loop runs based on controls you define. I defined my FOR as "all the cells just changed that intersect column D."
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
As per forum rules, continue your discussion here, not in Private Messages.
Please post your question here;
Trying to do this: If anything in column D, then put period in column E.
ALSO
If anything in column A or B, then put the current date in column I. (code below for this)
Please Login or Register to view this content.
When I use the above together with the below... they clash. Any way around this?
Please Login or Register to view this content.
I did not/do not/will not use an ACTIVECELL reference in a ws_change macro. Didn't we talk about this already?
There can only be one ws_change macro. Anything you want will need to be built into the one macro.
Please Login or Register to view this content.
Gotcha... thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks