Help with my VBA Code

[rv02]

Dear All

I have managed to write the following code with the help from this forum. But I am stuck in one bit ad I am new to VBA and will appreciate your help.

Basically, this code will look at my customers and if they have spent more than 1000 pounds and agreed to receive email and its been more than 30 days since their first purchase then the cell where their surname (column B) is will start flashing for two seconds and the date when I get the reminder is recorded in column J .

When I run the code everything works fine and the dates are entered correctly, however the only cell that flashes in B5 even though cells B7 and B9 should flash as well since they meet my If criteria.

I think the line Set myCell= .Cells(I, 2) is not working properly as it doesn't move on to the next cell to check whether it needs to flash or not.

I have attached my code and any help is much appreciate it as I need the code to make all the cells that meet my criteria to flash rather than just the first one.

Please Login or Register  to view this content.

[DarthVader68]

rv plz don't cross post, you posted this thread here and in www.mrexcelforum.com

[rv02]

Hi

Sorry if this was not allowed, I thought it is Ok as these seemed t be different forum.I just really need an urgent answer I am I need t complete this urgently for my work. I can remove the other post if this is not allowed.

[Richard Buttrey]

Hi,

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[rv02]

Thanks for this. I genuinely didn't realise this. I have posted this in other forums and the url are
http://www.excelguru.ca/forums/forum...BA-Programming
and also http://www.mrexcel.com/forum/excel-q...ions-code.html

my intention was in no mean to waste anyone's time I just thought that it will help me to get an answer quicker. Sorry for any inconvenience but u really will appreciate any help on this . I am happy to remove the other posts

[Arkadi]

The problem is that you need to reset x back to 0. X is already 2 after first time, so no flashing occurred for later loops

[rv02]

thanks. Is there any way you can send me the line of the code so I can ideally add this to my code as I am am a novice in VBA

[rv02]

Just to say I managed to do this and it works fine. Thanks, I set x=0 before it starts again. The only question is that it is flashing one at the time, is there anyway I can change the code so that all the cells that meet the criteria to flash simultaneously? any help with the code and the actuall code will be appreciate it.I am nearly there

[Arkadi]

Glad you did it on your own, I would have said pretty much what you did. I'm on my cell so can't solve the simultaneous thing now, but it is possible, with new code since you would have to check all cells in range, store those that meet criteria, and THEN flash. I'll look into it later or in the am.

[Arkadi]

Hi rv02, about your flashing simultaneously... Try the code below... The date will update during the check, and so before flashing, but the cells will flash together....

Please Login or Register  to view this content.