How to make excel worksheet cells flash using vba

[@rajnajat]

Absolutely brilliant ! Keep it up ..... you are very focused and precise beside having a professional voice ! Thanks a Ton !

[@wasimbader9170]

THANK YOU FOR THE TUTORIAL AND BIG THANK YOU FOR MAKING ME START FROM SCRATCH, AS YOUR FIRST VIDEO " SEARCH FOR DATA" AND YOU HAVE SEEN MY COMMENT " IT WENT OVER MY HEAD" NOW WATCHING FEW VIDEOS FROM DIFFERENT TUTOR AND DOWNLOADED THE BOOK AS WELL " WILEY EXCEL VBA FOR PROGRAMMING FOR DUMMIES 3RD EDITION" NOW I AM CONFIDENT WITH SO MANY SYNTAX AND WHY WE USED SELECT, OR DIM, OR SET AND SO ON. THANK YOU FOR TODAY AND FOR FUTURE. REGARDS :)

[@Medzo2]

Thanks a lot for this. I still have some little issuses with my worksheet as i am a beginner but this is exactly what i was looking for. I'll get back at you ASAP. Great work M.

[@sasavienne]

Simply amazing. 🌟 🌟 🌟 🌟 🌟 Thank you so much.

[@essicco]

Hi Dinesh, I have a task of Automatically loading an Excel Spreadsheet from my Hard drive everyday at 6:00 am and Append to a Table in an Access Database at the background i.e.(without logging on to my computer). Is there a way accomplish this? Thanks

[@rkferguson]

Nice. What if you wanted to have the cell change color based on content and when that cell changes color, automatically stat the flash macro?

[@Exceltrainingvideos]

You can use an IF condition and then call the macro that flashes the cell contents. This link will help: www.exceltrainingvideos.com/how-to-make-excel-worksheet-cells-flash-with-vba/

[@anonime395]

Is it possible to make search result cell blink or flash? Cuz it take a while while i notice which of the many cells on screen excel found using search. Default rectangle for search result is barely visible.

[@Exceltrainingvideos]

The cells in question are highlighted in red, font color is white and the blinking is clearly visible.

[@MrAsk2025]

thankfully to Dr.Raj for the video it's so helpful .. i was trying to make the cell flashing with reference to column in time not date.. for instant the column is hours compared to system time .. when the time reach like 2 hours the cell flashing ... but i couldn't do it .. i will appreciate if you help me with this matter

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/tag/how-to-make-excel-worksheet-cells-flash-with-vba/

[@jackpun3024]

Thanks a lot for the video.

[@Exceltrainingvideos]

+Jack Pun Glad that you found the video useful!

[@fordtsai234]

This is a very helpful tips, but i also wanna know how to make shapes, pictures or objects flash or blink? please help Mr. Dinesh... thank you.

[@Medzo2]

I really don't know what i'm missing but i'mve having an execution error "9" on the following line from the module 1: lastrow = Sheets("sheet1").Cells(Rows.Count, 1).End(xlUp).Row It always sends me back to bebbug but i don' quite find the error. Same here, module 2: With ThisWorkbook.Worksheets("sheet1").Range("C2:C6").Font Help please.

[@faizbhojani6740]

i had the same issue

[@rajnajat]

Could you please tell me , as to what change should I make if I want to make the cell flash when its cell value is >=3 ?

[@shaukatsamad2510]

Sir, the excel sheet I have there isn't Developer Column so it very tuff to go thru according to yr instructions...... pls advise...?????? I have desire to learn it....

[@JbpLv19]

Dear SirHave you done any video regaring excel 2010 with this problemI have a formula with many checkboxes and I need all the checkbox values into one cell in excel?Best regards //Anders

[@krn14242]

Thanks Dinesh. Would love to see a view out your window to see all the street noises below. :)

[@Exceltrainingvideos]

+krn14242 Sometimes I also wonder how to avoid the car horns, people smashing spices in the neighborhood and barking dogs! Would love to show you the view out of my window.

[@wasimbader9170]

+Dinesh Kumar Takyar ITS PART OF OUR CULTURE, CANNOT AVOID IT SIR, UNLESS WE ARE AT MOUNTAIN TOP AND NO ONE IS THERE, ITS LIFE AND BELIEVE ME ITS NICE AND LIVELY.

[@JosephArouna]

Hello ! This tutorial like all the others is very useful. But by wanting to reproduce it to adapt it to pratuque cases, one loses completely because all the data on the sheet Excel are not presented. For example, we do not know where the "mydate1; mydate2; datetoday1; datetoday2" is on the Excel sheet! Really thank you very much for helping us more.

[@Exceltrainingvideos]

Those are variables!

[@JosephArouna]

Dinesh Kumar Takyar : Thank you very much. I finaly find my way ! once more thanks.

[@Couragetogrowth]

Thank u sir, I am benefited by watching your video. Sir, but one request !!! Can you recommend some books from which I can learn complete Excel VBA with codes?

[@Exceltrainingvideos]

Refer to www.exceltrainingvideos.com website

[@Couragetogrowth]

Thank u .....a lot sir...

[@patidarramesh5298]

plz to tell me how to make cell value is blank and than when comes any value or text automated copy paste other cell or other sheet and after when copy paste value is stable

[@Exceltrainingvideos]

Place some value in Range E1 and then use: Sub copyValue() Dim myVal If Range("E1") "" Then myVal = Range("E1") End If Range("A1") = myVal End Sub

[@kaanapadhiyar1143]

👍👍👍👍 sir plz share code for practice

[@Exceltrainingvideos]

www.exceltrainingvideos.com/tag/how-to-make-excel-worksheet-cells-flash-with-vba/

[@mdidrus6805]

I dont have developed option in my Microsoft office 2016 .what I have to do

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/how-to-display-developer-tab-in-microsoft-excel-2010/ Works also for Excel 2016.

[@jseun7]

Hello Dr Dinesh, I stumbled into your lessons looking for a solution and your tutorial is somehow interesting. But I have not find a probable solution to the idea I want to solve. Please can you enlighten and help me on how to find a solution to this question using vba Questionddl = dropdownlistI have four dependent ddl in sheet1 and in sheet2 I have a list of data.How can I loop through the data in sheet2 to in order to be relative with the selection on the ddl and then display the output of the ddls in Sheet1?Egddl-1[Monday] ddl-2[Windy] ddl-3[Night], ddl-4[Beans]ddl-1[Monday] ddl-2[Sunny] ddl-3[Day], ddl-4[Cake]ddl-1[Monday] ddl-2[Stormy] ddl-3[Day], ddl-4[Tea]ddl-1[Monday] ddl-2[Dry] ddl-3[Night], ddl-4[Water]ddl-1[Monday] ddl-2[Normal] ddl-3[Night], ddl-4[Beans]When I select Monday from ddl-1, I was able to display all the row containing Mondays. But what I wanted is to be able to narrow down my list as I select from ddl 2 -4.If I need to see output with Monday-Dry-Night-Water. I SHOULD BE ABLE retrieve only one row from Sheet2 and display it in sheet 1.In essence I should be able to get this query: - ''Select Monday from List where Day is Dry and Time is Night and choice is Water'' I am hoping there may be a vba ways of doing it.Thank you

[@harsamcreation5899]

Thanks DInesh

[@mdyaseen3482]

you are really great sir, its help me so much and hope you can see my previous email which i have email to you

[@Exceltrainingvideos]

+Md Yaseen Thanks!

[@mdyaseen3482]

+Dinesh Kumar Takyar Sir how can i get suppliers details when i select sub item from the user form for example if i want to purchase a computer, VBA to show only computer suppliers and details of the supplier

[@indianmonster1445]

Supppppppppppeeeeeeeeeeeeeeeeeeeeeeeeeeeerrr

[@Medzo2]

Hello?