Never thought that this will happen in Excel. Fantabulous and hats off to you. Excellent explanation and teaching. Felt that you are in front of me. Definitely, it will help me in my other dashboard for an alert. Learn a lot of things...
@Officeinstructor4 жыл бұрын
What a nice and motivating comment... Thank you... Truly appreciated
@rajchannalchainpura89023 жыл бұрын
Excellent explanation and teaching of Blinking Cells and it will happen in Excel we never thought , Excellent Task ✌
@SolomonKinyanjui_sk4 жыл бұрын
This is wonderful and I'm going to apply it in my data analysis. Excellent work. Keep it up Sir.
@stacywilliams79314 жыл бұрын
Beyond amazing...and guess what? I haven't watched the entire vid yet. Nabil's vids are always out of this world!
@Officeinstructor4 жыл бұрын
I'm thrilled from your comment... Thank You Stacy
@123mailashish4 жыл бұрын
Best wishes n good health. TC Mr. Nabil. U need to be preserved so that u keep making excellent videos.
@Officeinstructor4 жыл бұрын
i will keep doing my best for my wonderful followers
@Pankaj-Verma-4 жыл бұрын
One of the best video ever seen on Excel topic.
@Officeinstructor4 жыл бұрын
I appreciate your nice comment... My followers deserve the best
@rickkeev49194 жыл бұрын
Great video. I would recommend to your viewers to use a named range for your totals comparison cells so as transactions are added the code would still work.
@Officeinstructor4 жыл бұрын
Thank you Rick for the recommendation
@dddoda4 жыл бұрын
One thing I'd do about cell D1. Add a macro button over it, with a text, such as "Stop Blinking." The macro attached to the button would type the "1" for you. That way, all you need to do is use your mouse to click on the button instead of going to D1, typing in a "1" and then hitting enter. You could even add a macro if statement to it, saying if there is a 1 already there, to delete it. So you can go back and forth.
@sasavienne4 жыл бұрын
You are amazing. Thanks indeed Nabil for all your valuable efforts.
@Officeinstructor4 жыл бұрын
Thank you for the nice words
@nadermounir82283 жыл бұрын
Amazing trick. 👏 Thank you Nabil 😊
@Officeinstructor3 жыл бұрын
Glad you liked it
@amolmane87474 жыл бұрын
Nice information and presentation as well....new commer will also understand with the help of your presentation... thanks for sharing!!!!!
@Scaw4 жыл бұрын
A very clear, nicely paced presentation. I look forward to more of them.
@sheshaankpydikondala93764 жыл бұрын
I never thought about this.. excellent tutorial
@Officeinstructor4 жыл бұрын
Glad you enjoyed it
@alpeshpopat17024 жыл бұрын
Excellent work sir, please launch more videos on macros
@pnagarajkumarbe3 жыл бұрын
Brilliant. Also the animation is pretty good. Can you tell me what is the tool you used for the animation.
@Officeinstructor3 жыл бұрын
Thank you. For animation I only use PowerPoint. For recording I use Camtasia Studio
@stevennye50754 жыл бұрын
Nice combination of techniques!
@rupeshkhubchandani43424 жыл бұрын
Tremendous work... Good morning.
@jutatip_rodjanasiribut4 жыл бұрын
Great job!. It's fun. Will of course apply this to my work :)
@jutatip_rodjanasiribut4 жыл бұрын
When I tested, it got error at Worksheet Change said that it expects to call Variable or Procedure, not Module (BlinkCell). Any hint? thanks
@zaighamuddinfarooqui17054 жыл бұрын
What a great idea. Very well done Mr. Nabil. 👍👌👌
@Officeinstructor4 жыл бұрын
Thank you my loyal friend
@Mitr2u4 жыл бұрын
Cant copy the code, it requires memberships
@Officeinstructor4 жыл бұрын
@@Mitr2u Membership is a click away... it's totally Free
@shaamilstudios15853 жыл бұрын
Great Work ! Very rare knowledge
@prasathj74363 жыл бұрын
Excellent Sir !!!
@Officeinstructor3 жыл бұрын
You are most welcome
@vincysigma4 жыл бұрын
Wonderful.. Tricks.. Thank you Sir.
@nairobi2032 жыл бұрын
Nice explanation.... Great
@dhunpagla38714 жыл бұрын
Superb Mr Muraad ...Thanks 👌🙏
@Officeinstructor4 жыл бұрын
I'm happy you liked it
@christopherschembri77934 жыл бұрын
Thank you for this extremely useful tip.
@Officeinstructor4 жыл бұрын
Glad you found value in it
@rajivjat4 жыл бұрын
Way of presentation and voice quality are excellent..
@Officeinstructor4 жыл бұрын
Thank you... The Best Is Yet To Come
@rajivjat4 жыл бұрын
@@Officeinstructor Does the recent announcement from Microsoft about VB is also applicable to VBA also ? Please guide about the future of VBA.
@ashoksahu95464 жыл бұрын
Excellent video sir.
@Officeinstructor4 жыл бұрын
Thank you
@nileshmetkar17374 жыл бұрын
Great sir.. concept is good.. your video animations is attractive.. can you plz guide me how to add animation in video
@Officeinstructor4 жыл бұрын
I use PowerPoint and Camtasia Studio
@sarthakwebsoft4 жыл бұрын
Wonder full video. May i know which software are you using to create this video?
@Officeinstructor4 жыл бұрын
Camtasia
@rajeshshah67584 жыл бұрын
Awesome presentation and helpful too.💙
@alaysispatrick09203 жыл бұрын
Nice video blinking. Please made video blinking sheet name wise. For daybook with on/off button. Cell A1,g7,E3,c4 blink.
@saravanansharan33944 жыл бұрын
Really amazing... Done a fantastic code
@Officeinstructor4 жыл бұрын
Thank you
@salahmed72734 жыл бұрын
Many thanks, Sir,, from Sal from Amman - Jordan
@taiyosangyo75303 жыл бұрын
This is very helpful sir, how to resume again blinking again of "H1" if you delete number 1 on "D1"?? thanks
@neelimakammila78914 жыл бұрын
Thank you for the video!! Please could you explain If Not Application.Intersect(Target, Range("B5:E19")) Is Nothing Then
@nponobeghuk4 жыл бұрын
When you modify a cell or a range somehow, the event will be called and Target is a reference to the modified range. Application.Intersect checks if there are some cells in common between two ranges. In this case Target (the one that you just modified) and B5:E19 (which is the range we'd like to monitor). Let's check scenario 1: you modify a cell inside B5:E19 range. In that case, Application.Intersect will return a range of cells that are in common between cells you just modified and B5:E19. Scenario 2: this time you modify a cell outside B5:E19 range. Application.Intersect will return Nothing, which is a kind of empty object. For the execution of our macro, we are interested in scenario 1, but actually the outcome of scenario 2 is a fixed value "Nothing", which is easier to track down. So instead of checking "did I click inside the range" (in which case the return of Application.Intersect would be unclear and we would have trouble setting the if conditional), we check for "did I NOT click OUTSIDE the range" (Application.Intersect returns Nothing if we click outside, and we use Not to discard all the clicks "outside" that return Nothing, and use all the other ones).
@Officeinstructor4 жыл бұрын
That's a wonderful explanation... Thank you .
@n4xlsolution6134 жыл бұрын
#nixelpresentation Voww.. How nice and simply you presented this tutorial. Enjoyed it. Thank you!
@Officeinstructor4 жыл бұрын
Thank you
@She_Tried_It5 ай бұрын
When I went over to view the Worksheet (Click Tab > View Code) 6:56 , I can't get back to the original code with the color changes. Crtl+R 8:50 didn't get me back to the module. Was I supposed to save it first? I don't have the heart to start over if I lost it...
@ocean99a4 жыл бұрын
Dear Officeinstructor Thanks for this excellent explanation I tried to register on your site more than once but I was unable to enter the registration page And every time a blank page appears and there is nothing.Thanks again and please solve this problem
@Officeinstructor4 жыл бұрын
Thank you for the nice comment. I added a different download link to the video description. You can use it until I fix the broken link
@georgetosounidis55454 жыл бұрын
Great video! Liked how you explained the built of the VBA code. Could we use a key combination which would be recorded by excel to stop / re-enable the blinking (or any other macro), not typing 1 etc? like ctrl-break? Subscribed and bell clicked! Keep it up :)
@douglasburnside4 жыл бұрын
I was so disappointed watching this video. Oh, it is a wonderfully done video, full of excellent information and I could even understand the logic of what you are doing. But I was hoping you were going to explain some hidden magic that would let me make a blinking cell using just the choices within the Excel conditional formatting function, without using VBA. I guess I'll just have to finally force myself to learn VBA. Thanks for the great video. Upvoted.
@Officeinstructor4 жыл бұрын
Thank you Douglas for the comment... I agree that any solution without VBA will benefit more users since not everyone is using VBA. However, when you have hundreds of thousands of viewers, and many of them are advanced users, SOME of the tutorials are dedicated to VBA curious users. The exercise files have been downloaded over 35000 times from my website in one week of posting ... Isn't that an indicator? If I don't like SUCHI...it doesn't mean it should be banned. In life, it is IMPOSSIBLE to make everyone HAPPY although I wish... and, TRUST me I do my best
@jasonstatham74243 жыл бұрын
Many thanks
@Officeinstructor3 жыл бұрын
You are welcome
@rijomathew4 жыл бұрын
I do this in a lot fewer steps.. no coding... Conditional formatting, time function and a hidden collumn
@Officeinstructor4 жыл бұрын
Great Rjo... It will be good to share your concept so everyone can benefit.... The goal of this channel is to share our knowledge
@linabella95234 жыл бұрын
@@Officeinstructor if your goal is to share your knowledge why you dont share code.because im a new in vba and with the video i didnt succes. i dont know whats wrong.
@SolomonKinyanjui_sk4 жыл бұрын
Hi? In case i have two or more independent cells how can I ensure they blink according to given condition independently?
@jaysolanki83664 жыл бұрын
Can We reduce the wait time further less than one second? Is that possible?
@Officeinstructor4 жыл бұрын
No
@jaysolanki83664 жыл бұрын
@@Officeinstructor okay thanks for ur reply😊
@IvanCortinas_ES4 жыл бұрын
Thank you for the video. One question please!: When I execute the code and change any number and start the blink, I see the pointer of mouse in "mode hibernation". Thats possible the state of the pointer of mouse normal? Thank you!!
@Officeinstructor4 жыл бұрын
The reason is, you are using Excel as usual while a code is continuously running in the background... and that slows Excel. This kind of functionality is more "Showy" than "Practical"
@Randy_G4 жыл бұрын
Thank you. Liked and Subbed.
@abaurre3 Жыл бұрын
The solution works, but the UX, at least for me, is kinda lackluster. The cursor keeps cycling between the "busy" graphic and the regular cursor as long as the while loop is going. The DoEvents parameter makes it possible to edit values while it's running, but the cursor is kinda janky and laggy, making it feel like the spreadsheet is lagging or hanging.
@Pitter57754 жыл бұрын
Hi Sir this codeing is verygood but when i applied .the cursor is constantly spinning..means getting slow.Plz suggest
@Officeinstructor4 жыл бұрын
That's normal because a macro is running while you use Excel
@atiqsarwar42224 жыл бұрын
How can I apply this to long data set, like I want to use this in employee probation period expired or not...
@Officeinstructor4 жыл бұрын
Definitely NOT recommended... this code is more Showy (To impress your boss) than practical as it slows Excel
@queeniegonsalves4174 жыл бұрын
Nabil u r superbbb. But VBA doesn't works on my desktop ...entire excel goes for a toss 🥴🥴
@Officeinstructor4 жыл бұрын
Then just watch the video... The Best Is Yet To Come
@mnsoyan4 жыл бұрын
Brilliant!
@kiranchoudhari52254 жыл бұрын
My cell remains orange coloured if i close my editor. Do i have to keep the editor running/minimized everytime i open the file to keep the code running?
@Officeinstructor4 жыл бұрын
That's weird... Closing the VB editor should not affect the functionality
@niyiabdul62434 жыл бұрын
Thank you for the video. But just one problem. In executing the code, my VBA editor keeps flagging "Set CellToBlink = Range ("H1")" as being incorrect. I'll appreciate any help on this, sir.
@Officeinstructor4 жыл бұрын
Try again
@CBTstreams4 жыл бұрын
Would you know how to do this? Column A is a previous total Colum B is the new total If the value in the adjacent cell in Column B to Column A is lower, highlight red. I need it for the whole range i.e. B1:B52 however has to also be if A1>B1 Red, if A2>B2 Red, etc etc I tried manually doing the conditional formatting and when I use the sort option, the formatting doesn't keep the rules, it changes the formulas
@souravgupta44164 жыл бұрын
Can I get the VBA Code used
@Officeinstructor4 жыл бұрын
Read the video description
@MAHESH_IRCON3 жыл бұрын
Excellent
@Officeinstructor3 жыл бұрын
Thank you so much 😀
@piroozpakdel94152 жыл бұрын
Thank you
@viswanathn32634 жыл бұрын
Awesome logic
@Qtrainer4 жыл бұрын
So what do you do if Alt + F11 does nothing? Version 2002
@Officeinstructor4 жыл бұрын
Time to upgrade my friend... we are in 2020 (just different order of digits from 2002)
@Vicky_view4 жыл бұрын
I want to flash multiple cell , how i can do this
@Officeinstructor4 жыл бұрын
You need to modify the code but I do not recommend that as it slows the performance
@mindsetuk4 жыл бұрын
This is a great tutorial however .... The website,code and sheet can't be downloaded or don't work. And the code works but hangs - it's in some never ending loop I guess but I am not good enough to get it to stop. Very frustrating!
@JPAlpano4 жыл бұрын
How did this work without saving the file as xlsm?
@ivanpap6344 жыл бұрын
Great!
@yujaliria84864 жыл бұрын
this is cool
@sandeshvartak51564 жыл бұрын
If my sheet is protected then what I need to add in vba script.
@OracleBizz4 жыл бұрын
Thank you sir
@arinarin87024 жыл бұрын
Can not download the code please
@suhailnbd4 жыл бұрын
Awesome
@Officeinstructor4 жыл бұрын
Thank you
@rainier-rawai3 жыл бұрын
Good work, very clear, thanks. Is it possible to modify a little bit: Can keep the « stop » by 1 in cell D1... but would like to have an automatic stop after 20 seconds... Is it possible?
@Officeinstructor3 жыл бұрын
Yes, you can. May be I create a tutorial on that in the future
@ahmadsharjeel18492 жыл бұрын
how to copy
@Janardhanreddys4 жыл бұрын
So VBA this wont worked out right
@dastagirshaikh97774 жыл бұрын
How can I apply this blinking cell formatting to the cell without condition.
@Officeinstructor4 жыл бұрын
Not recommended as it will slow Excel enormously
@rockiebhay54234 жыл бұрын
hi i want making data entry for company
@linabella95234 жыл бұрын
Officeinstructor if your goal is to share your knowledge why you dont share code.because im a new in vba and with the video i didnt succes. i dont know whats wrong.
@Officeinstructor4 жыл бұрын
Not only I posted the Exercise File but also I wrote All the steps in details on my blog site + the Code for easy copy and paste... There are over 35000 downloads in less than a week. To make this available to viewers and followers I host all that on my blogsite. I used to put a direct link for download then I became a victim of hack and my website crashed... To avoid this situation while I keep sharing everything (Knowledge , Time, Effort...) for FREE I ask viewers to register as Bronze members (Totally Free) to protect my website and my intellectual property. All details are in the video description.
@jerry1714604 жыл бұрын
I went to www.see-how.ca/blinking...but I couldn't sign up to become a member. The screen kept showing a blinking diamond in the middle and nothing else. In other words, I couldn't download the exercise file. Any help is appreciated.
@maikyboy63414 жыл бұрын
Sir, Can I download this example file ?
@Officeinstructor4 жыл бұрын
Sure, You can download the file and copy the code if you want. The link is in the video description. You will need to register on my blogsite (Free)
@Mitr2u4 жыл бұрын
Nope, Pay n Get
@Mitr2u4 жыл бұрын
@@Officeinstructor if it is free, then why it is available for brownz memberships
@subratadatta39144 жыл бұрын
I am failed to be a member www.see-how.ca/. Whats prob?
@Officeinstructor4 жыл бұрын
No one had a problem before... try again
@Saad.PS20094 жыл бұрын
استاذ /نبيل مراد محتاج كود لإخفاء المعادلات في الاكسيل مع خالص الشكر والتقدير والاحترام
@Officeinstructor4 жыл бұрын
إبعتلى ايميل و انا اقولك تعملها إزاى الايميل بتاعى على الويب سايت
@Saad.PS20094 жыл бұрын
saadidris42@gmail.com
@ahmadsharjeel18492 жыл бұрын
where is vba code
@niyazfazeenaniyazfazeena14957 ай бұрын
Wow
@izharisr4 жыл бұрын
How to save that file and how does work next time open the worksheet
@Officeinstructor4 жыл бұрын
dot XLSM format
@johnjacobjinglehimerschmid35554 жыл бұрын
meh.... I did this once and TBH it works but it's gimmicky. Now if you could get a GIF to work .... then make a flashing gif would be better IMO.
@Officeinstructor4 жыл бұрын
That would be a lot of fun if you can make your GIF blink conditionally
@johnjacobjinglehimerschmid35554 жыл бұрын
@@Officeinstructor quite a few years ago at a former job. Had a guy, who had some software, make me a gif that would start red then go to transparent ... say 2 second cycles. Used it in a web page to indicate that a tool status had just changed on our factory communication board. Would have loved to make it work in a workbook tho.
@vrmsali4 жыл бұрын
Plz indent the code. It is just a good practice.
@Officeinstructor4 жыл бұрын
Sure ... Thank you for your NICE comment
@prerit864 жыл бұрын
In what world is this conditional formatting?
@goodgame95912 жыл бұрын
I need out
@Ahmed-fq6si3 жыл бұрын
I still can't understand why you put such a noisy music?
@goodgame95912 жыл бұрын
im problem pressing comment
@sunilperera48374 жыл бұрын
Pbbperera
@sanjibpramanik92684 жыл бұрын
Sorry, but this type of code is not a very good idea, coz it slowdown excel.
@thesexiestguy4 жыл бұрын
Sanjib Pramanik, as of 07:52 17MAR2020, among 60+ people who commented on this video, you and I are the only 2 of such opinion... OP should tell his audience that such blocking calls should be best avoided... I was holding my breath hoping that he is not going to use ontime/callbacks... And this is clickbait, no where near conditional formatting but rather involved vba...
@sanjibpramanik92684 жыл бұрын
@@thesexiestguy Exactly, this is a clickbait. I think excel VBA coding is very easy to learn, but very few people actually know about how to write a safe code that harmless for our application and computer processor. 90% of them can't try to understand why they should use array instead of use range object or cell reference. Excel VBA event's are very useful, but using event to create a blinking cell that change fill color randomly with some conditions is nothing but just a funny thing to show kid's 😜😁 Thanks for your reply 😇
@vivek-qp1zs4 жыл бұрын
Total confusing 😉 sry not a student of computer
@Officeinstructor4 жыл бұрын
On top of that you should be at least an intermediate user of Excel to learn VBA. I create Tutorials for users of different levels
@markfalina91608 ай бұрын
SPEAK ENGLISH!!!!!!!!!!!!!!
@IFSJAIPUR4 жыл бұрын
avoid vba codes , do as much as you can do without vba , if you have to write a vba code, file need to be saved to xlsm format , then opening macro files is not considered safe
@saleembukhsh76824 жыл бұрын
How can apply this to a large number of cells?
@Officeinstructor4 жыл бұрын
Not recommended... This functionality can only be used sparingly as it slows Excel performance