Hi guys,
i'm new to vba but maybe somebody can help me, this is what i would like to achieve:
if cell H10= "Not Started" clear contents in range D10:F20, but if this cell H10 will contain anything else, do nothing.
I would like to perform this action without any buttons if possible.
Thanks in advance
Last edited by intex; 07-21-2014 at 03:22 PM.
Put this code in the worksheet module:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
use this code...
Cheers!!Please Login or Register to view this content.
Olly,
maybe i'm doing something wrong, but it does nothing. I have put this code to module, but nothing. Maybe it's because the H10 contains formula?
Did you put it in the WORKSHEET module?
(right click worksheet tab, click 'View Code')
excelliot how to activate this macro automatically, because now i have to run it manualy. I would like execute this code every time the words are changing in H10 (the H10 can be "Not Started","Active" or "Completed").
Also the H10 contains formula
Thanks
Olly, yes i have put it into Sheet1(Sheet1), and nothing happens when formula changes.
Also the H10 may contain "Not Started","Active" or "Completed"
Attach your workbook, please.
Scrub that - realised what's going on.
You're not actually changing H10, are you - it's just the value returned by the formula in H10 which is changing...
So use:
Again, make sure you put it in the WORKSHEET module.Please Login or Register to view this content.
deleted attachment
Last edited by intex; 07-21-2014 at 03:25 PM.
Yes, brilliant it works now, you are genius mate!!!
Excellent, glad we got there! Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks