Forum Discussion
Excel blinking cell
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.
Mr. Jamil Mohammad
Thank you for taking time in my query - if it is not too much to ask, may I request for a little more help re:VBA
imagine I would like to blink cell A1 if the value of B1="" (or blank space) inside the worksheet named "DATAENTRY" - how would the program be written (macros?)
again, Thank you for your time
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
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.
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