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

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.

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?

your channel is the Best

Very great video and nice work!!!

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

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

4 жыл бұрын

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.

Superb...

@ExcelDestination

5 жыл бұрын

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

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

@ExcelDestination

4 жыл бұрын

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

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

super, good.

@ExcelDestination

2 жыл бұрын

Thank you

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

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

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

3 жыл бұрын

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

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.

Can we make the calls blink 10 times only?

@ExcelDestination

4 жыл бұрын

Yes!

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

3 жыл бұрын

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.

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

4 жыл бұрын

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

4 жыл бұрын

@@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

4 жыл бұрын

@@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

4 жыл бұрын

@@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.

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

@ExcelDestination

4 жыл бұрын

can't say anything without looking at code. share your file at exceldestination@gmail.com.

@sandeepkumar-cx4or

4 жыл бұрын

@@ExcelDestination it works i do this

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

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

3 жыл бұрын

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

@rajeshkumbar8117

3 жыл бұрын

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

@rajeshkumbar8117

3 жыл бұрын

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

@rajeshkumbar8117

3 жыл бұрын

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