Forum Discussion
Excel blinking cell
- Mar 13, 2018
Hello Lorenzo,
Thanks for the feedback. as per your PM. I have updated the macro. so that when G27 is empty, the B27 will start flashing. it will stop flashing when you put a value in G27. Please download the attached workbook which has the macro.
Hi Lorenzo,
Please see attached workbook with Macro. try to put some value in A2 and unless you put a value in B2 it will keep flashing.
Mr Jamil Mohammad
I couldn't believe I receive your reply in such a speed!!
if I may bother you again - can you rewrite the macros just for A2 and B2 - no need for the whole rows -
Thanking you for your FANTASTIC reply
- JamilMar 13, 2018Bronze Contributor
Hello Lorenzo,
Thanks for the feedback. as per your PM. I have updated the macro. so that when G27 is empty, the B27 will start flashing. it will stop flashing when you put a value in G27. Please download the attached workbook which has the macro.
- Lorenzo KimMar 15, 2018Bronze Contributor
Attached is the excel program I created for costing purposes.
your blink macro looked ok but I can not imbed it into the program as I have very little knowledge of VBA. your kind assistance would be appreciated very much
I don't know if this has sent the file "EUREKA Desking Program (per configuration).xlsm
if not pls tell me how to send it to you - so that you will better understand what I want for the blink.
Many many thanks
- Lorenzo KimMar 15, 2018Bronze Contributor
Mr. Jamil Mohammad
Good day
can I trouble you again (maybe for the last time)
could you re-write the macro for just G27 to blink whenever B27 is blank (no need to reverse)
i.e. G27 will blink if B27 is blank - that's all
How can I send you the File for you to understand better.
I can not see "attach file" option
Thank you for your patience and assistance
- JamilMar 15, 2018Bronze ContributorHi Lorenzo,
If you click "Quick Reply" icon, then you dont have the option to attach workbook.
If you click "Reply " then you can attach the sample workbook.
- Lorenzo KimMar 13, 2018Bronze Contributor
Mr Jamil Mohammad
Thank you very much for your assistance