Vba to Make Cell Blinking in Excel

[@barrywhite8678]

Started out with the beginning of the 5 1/4 disk with computers, but I really did not get the programming down, but you are a wiz! Thanks so Much for you Tutorial.

[@hdraman111]

From now on this is definately my DESTINATION FORALLTHINGS EXCEL. You are now officially my friend. That video was the most simple and so explanatory. A couple of others I viewed, were just confusing. I have been trying to master the blinking codes for a few weeks now. You have built my confidence to a level where I will hopefully be successful. I have liked and subscribed, though would also like to know if you have a Paetron Account. ONCE AGAIN, THANK YOU.

[@jgr7127]

I don't know anything about programming so I'm very thankful to u! ❤️ Would you also know how to change the blinking speed from 1 sec into half a sec?

[@rallyrobb943]

I recently found your channel and have already discovered multiple videos that have been very helpful. Thank you very much friend!

[@funnyschtuff]

Very great video and nice work!!!

[@hazemali382]

your channel is the Best

[@saranganathan7908]

Very useful for me thanks, i ask one more request how to implement in conditional formatting ie. if condition is true then activate automatically otherwise disable , pls help me bro thanks and regards

[@ExcelDestination]

thanks for your comment! you can color any cell using conditional formatting. you can write condition, if condition is true it would color if condition is not true then you can make color disappear or change color.

[@aamir6282]

very nice video sir can do it without button for if our cell have spacial value

[@jessicabanhos]

What about without a botton to start blinking? What command shall I change or add? Thanks for your very good explanation!

[@ExcelDestination]

You can use the same code on event programming. You can try for "Selection Change" event. where once you enter, code will be executed.

[@Ali-uz8qg]

At 2:09 when you say "Double click on any command button, that will take us to VBA window". When I did that on the Start Button, it opens the window, but not the column or selection frame on the left, where you select 2:20 the "Workbook" / Insert / Module. I do not see that. What to click to show that left Column?

[@ExcelDestination]

To reach to VBA Editor (where you can write code) there is shortcut Alt+F11 or you can double click on command button (but at that time it Design mode should be on) ...........You can watch "VBA for Beginner" series, I have uploaded to learn from starting.

[@Ali-uz8qg]

@@ExcelDestination - I appreciate your quick response. I will try it tomorrow. At the same time, I will watch your "Beginner" video. I am new to this. Thanks for the tip and will confirm when I get it right. Bye for now.

[@Ali-uz8qg]

@@ExcelDestination - I managed to get the flash working. However, even the shortcut Alt+F11 didn't work, and of course neither the left column frame appears as seen in your video. That is even though the "Design View" was On. *But I did figure out how to insert the Module.* On double clicking the 1st CommandButton1 (Start) *the Toolbar on the button itself* shows an "Insert" button which then inserts the Module1. But after I close the Module and if I want to edit the Module1, there is no easy way to go back except to click on "Object Browser (F2)" and search for the Module1. It works though. It has been an interesting learning experience for me. Your presentation of a range of cells flashing was easy to follow. I was wondering what the sub-routine would be if I wanted to flash say 3 cells or more not contiguous to each other. Meaning 3 cells that are apart from each other and not in a range as per your video. *For example: 3 different Cells A1, B4, and D2 to flash together in 3 different colors.* Once again, I thank you for your assist. I'll also be watching your VBA beginner video.

[@Ali-uz8qg]

@@ExcelDestination - I figured out the sub routine code for selecting non-adjacent or non-contiguous cells. But still haven't figured out how to assign different color codes to each cell. *For other learners on this message board:* I am sampling the code below: (Instead of selecting range("A1:B5"), write it the following code below: (I have selected 3 different cells): If Worksheets("Sheet1").Range("A1, D3, E9").Interior.ColorIndex = 6 Then Excel Destination - If you could provide a sub routine tip for the different color codes to each cell, that will be wonderful. Thanks.

[@Whatisnottaken]

Pardon my ignorance but of what use is the blinking? It is not like when you open the file, the blinking reminds you of a task or to draw you to something urgent. You have to manually click to start and stop. Looks like it is for fun.

[@enochauston4068]

super, good.

[@ExcelDestination]

Thank you

[@pakidar1]

For me it works just in on sheet , can you halp me whit the same macro , but in the second sheet , for example in sheet 2

[@ExcelDestination]

you can modify this code to work for 2nd sheet also.

[@rajeshkumbar8117]

Hii sir very goodmorning I am finding very much difficulty while searching a text in drop-down list I have to select the required text manually from 550 names Is it possible to type short text and the drop-down filters the text containing names in top order.

[@ExcelDestination]

yes, it is possible, let me create a tutorial for it.

[@rajeshkumbar8117]

@@ExcelDestination sir by when you can create it ?? Could please tell me the timing.

[@rajeshkumbar8117]

@@ExcelDestination sir when you are going to create tutorial on this please tell me....

[@rajeshkumbar8117]

Sir are you going to create the tutorial sir ....

[@jeraldthalaiva85]

Sir, how to find VBA color code ?...i need red colour to this cell how to apply that?

[@ammarhisyam8686]

Excuse me sir. I have 1 question why after I save the excel file then I open it back the start button is not function anymore

[@ExcelDestination]

Not sure 100%. But I feel, you need to save your excel file in "Macro Enabled Format", which is ".xlsm". Then all of your VBA Code and command button should be saved properly. Try is, if it doesn't work, let me know.

[@tere1198]

Can we make the calls blink 10 times only?

[@ExcelDestination]

Yes!

[@NaveedAhmad-HFD]

If i want to colore & blinking both in active cell where & where is curser Behavior of the active cell is colored & blinking It all shows Presence position of curser

[@hemantgoyal409]

Sir can u please tell how can I run my macro by signing in web or can run my macros in excell as a web application

[@Am_Karthik]

This macro is not working in background color applied cells, it's it's removing the cell when applying start and stop

[@ExcelDestination]

can't say anything without looking at code. share your file at [e-mail].

[@sandeepkumar-cx4or]

@@ExcelDestination it works i do this

[@mayurchauhan2065]

Superb...

[@ExcelDestination]

Thanks for your appreciation! Please share this further. It will help my channel a lot.

[@speaktruth2830]

First message run time error 1004 below Method 'On time ' of object '_Application' failed