Cell to flash if contains a value

Hi all

I have a cell that is condition formatted that if a value appears the change to red, CAN I get that cell to Flash when occupied. ???

Pete

Hi potholes,

It looks like some code has been written to do what you want. See this link:

https://ccm.net/faq/29065-excel-a-ma...e-cells-blinks

If that doesn't help then keep asking.

Hi all

Marvin put me on to this code and I only need it to flash if cell N6 or N13 has a V or W

will this code do it for me please.

Please Login or Register  to view this content.

Thank you in advance

Pete

Hi all

In post #3 here is some code unfortunately it is not working when something is entered into cell N6

Can anyone assist please

Pete

it is not working when something is entered into cell N6

Hi Peter

It will never work as there is no event triggering the cell change...Put this code into your sheet Module

Please Login or Register  to view this content.

Another link here

Good afternnon Sintek

I have 2 sets of code with the same name here, I am unsure how to change it.

Please Login or Register  to view this content.

Pete

Nothing is just plain sailing with you is it lol...
Will have to incorporate all the events into one...

Hi Dave ???

I haven't seen you around lately/

You been talking to Ali again.
Ali has been teaching many aspects Excel and behaviour over the last months or so
to the point I think she has gone grey.

But I have the absolute respect for her.

Many thanks for your help here/

Pete

It's my blood pressure I'm having to control, Pete. Hair is fine - just one grey streak in what is otherwise still very dark hair, and that was there long before I 'met' you.

Sintek hasn't conferred with me - he's reached that conclusion all by himself.

OOPPS

The boss lady was watching me again.
NO INSULTS INTENDED.

No offence taken - skin like a rhino's.

Hi All

Is there anyway of joining these 2 statements because they are clashing
due to the first line Statements.

Please Login or Register  to view this content.

Many Thanks

Just have one sub

Please Login or Register  to view this content.

Hi All

I guess it would help if I put up the correct code causing the grief.

Please Login or Register  to view this content.

Oh, God!

YES, Pete, it certainly would ...

That what happens when you try to program and put out family fires at the same time.

But I am the nut on the keyboard.

Multi-tasking - necessary life skill.

Ali

I have 3 Code functions that are clashing, for clarification should I put the file here containing the 3 clash of the titans. ???

Yes - let's get this resolved here.

Good Morning All

On advise from Ali I have placed this post here.

Attached is my file called Enduro_1, Thanks to the many that have had input in one way or another,
to get these 3 sets of code to work.

I have 3 Code functions that are clashing, If I try to do something on the front page the brute throws
back errors to me, I would appreciate if someone could sort this out for me please.

Please Login or Register  to view this content.

73s

Pete

OK - so I've moved the clear macro to its own module (as was suggested by one of the experts the other day) so that now works, and I've sorted out the conflict, I think.

Can you now test the sheet and see if the two sets of code remaining in the worksheet itself are working as you expect?

If not, tell us (a) what each is meant to do and (b) what, if anything, is happening instead.

Good morning Ali


Thank you for taking your time away from your Family time to look at my file.

The code below is not working, when you enter a lowercase v or w into "Front sheet "
L6 it should turn into uppercase.

Re the other code, if you enter a rider number in " Front Sheet" D6 that has been Vetted
out or withdrawn cell N6 or N13 will flash. THAT IS OK..

For my edification, Please advise where the other Clearing module is located.

Please Login or Register  to view this content.

73s

Pete

As my Grandson would say " Your frusterating student"

Morning, Pete!

It's 0645ish here - the lark and I are up. The other half is still asleep and daughter is away for the summer visiting family up north. The cats have been for breakfast and gone again, so it's just me.

I am going to grab a second caffeine shot (bracing myself) and then I will see if I as another VBA novice can help work this out with you.

So for your edification, Pete, whilst I see if I can fathom what's wrong with that code:

Thank for that module NOW I know what he was talking about, ( Brain overload this week. )

I've gone back to basics with the capitalisation code.

Please test the attached thoroughly, making sure that all three codes are doing what they are supposed to do.

Originally Posted by AliGW

I've gone back to basics with the capitalisation code.

Please test the attached thoroughly, making sure that all three codes are doing what they are supposed to do.

Thank you this code stopped working now

If you enter 5 or 14 into D6 N6 should flask

Please Login or Register  to view this content.

Sorry, Pete - that was the wrong workbook. Please test this one.

Originally Posted by AliGW

Sorry, Pete - that was the wrong workbook. Please test this one.

Guess what now, They all work now Thank You .


I have one question tho, could some of those VBA codes go into their own module as did the clear codes. ??

Stand by for the next installment.

Regards

Your Adult Student.

Pete

Great!

This thread has now run its course - please mark as solved.

I have one question tho, could some of those VBA codes go into their own module as did the clear codes. ??

I've done the effort so I'm throwing mine in also.

Regarding modules v. worksheet - over to the experts! Maybe ...

Hi Rudi

Can you reply to my post 31 pse

Where can I download the PDF on learning VBA, someone sent me a link for Power Query, so
I would like the same sort of manual for VBA if it is available

Many thanks for your input.

73s

Pete

Link removed ... Potential copyright issue.

Amazes me how the initial request which was solved in post5 becomes a 3 page problem not even pertaining to the post title
Surely the clashes of the code should have been addressed in an entire new post?
Just my 3 cents...

Originally Posted by sintek

Amazes me how the initial request which was solved in post5 becomes a 3 page problem not even pertaining to the post title
Surely the clashes of the code should have been addressed in an entire new post?
Just my 3 cents...

Hi Dave

I refer you back to this post and the post sheets 28 29.

https://www.excelforum.com/excel-pro...ml#post5159423

You were not around so it may have been addressed in a different manner. I can't blame anyone for my lack of knowledge.


Peter

Surely the clashes of the code should have been addressed in an entire new post?

Under normal circumstances, yes. However, I instructed Pete on this occasion to do what he did as we were already getting a proliferation of threads, each overlapping in some way or another.

I have advised Pete to try to keep it simple in future - one thread (one issue) at a time so we don't get the confusion we have had in recent times.

Thanks for clarification AliGW...Now i get it
As Pete said...Referencing the other threads...I was not around for those where Rudi & yourself had assisted...

@Ali: maybe he got permission but ...

Copyright © 2013 by John Wiley & Sons, Inc., Hoboken, New Jersey
Published by John Wiley & Sons, Inc., Hoboken, New Jersey
Published simultaneously in Canada

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit- ted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http:// www.wiley.com/go/permissions.

I've removed the link as a precaution.

Probably a good move