Welcome to Exceldestination. We provide free videos on Excel Formulas, Excel Charts, Excel Best Practices, Excel VBA Development, VBA Programming, Reports Automation etc.
All Tutorials are based on real time usage of Excel and VBA and easy to understand.
If you find these learning videos useful please comment, like and share. Click on the subscribe button to join and get notified when new videos are released.
Keep Watching and Happy Learning!!!
For any Excel VBA enquiry write to : [email protected]
Website : exceldestination.com/
Live Stream URL:
rtmp://b.rtmp.kzread.info?backup=1
rtmp://a.rtmp.kzread.info
Пікірлер
Thanks Sir
আমার স্কেল সিট এ চার আইটেম আছে তিন নাম্বার টায় রিফ্রেশ হয় না একটা ভিডিও দিবেন প্লিজ
Your video is very helpful but I need help to find a Date between a range of dates I try to find out if a date in my list occurs during DST (Daylight saving time) or Standard time I need to calculate a time for an event in my spreadsheet and if the date will be during DST (Daylight saving time) they have to add 7 Hours if it falls during winter time that use standard time it should only add 6 hours So I have a list with 50 events during 10 year periods so I need to find out on every date if its durned DST or Standard time for that year I do have a table with the dates for DST start/end from 2014 to 2033
Thank you.
thank you so much su[er simple and easy
Thnx for this sir. But after this activity undo doesnt work.
the best! easy to follow and understand because not only you make the code but also you explain what is the action following the code! more vids Dude!
How to calculate weeks sir..
Awesome
Bhai isme variable to declare kiya he nhi
This is great and well explained, however I want to use this search facility in a textbox of a userform, can you show me what changed would be made to facilitate this please.
Thank you!! Can anybody tell me how to TRIM the text in this VBA code?????
Mean Paste Value
Wow. Very nice. thank you sir.
Sir If I closed file and reopen and add new data this steps doesn't refresh
Thank you. Really appreciate
Sir weeks kaise nikalte hai
Thanks
Thanks, How to pass range dynamically. eg today we have 12 records tomorrow may be we have like 120 records without edit vba code how we can pass it
THANK YOU! I DIDN'T GET AT FIRST, BUT THE SECOND ONE VOILA!
HOW TO EXCLUDE THE HOLIDAYS IN THIS CHART
Sir ye command button ke se open hoga
Good job
What will be the code if the nunber of excel file is keep on adding in the folder, and it not fixed number of excel files. Please guide, thanks!
Thank you
Thanks for the useful code. Is there any way to make excel use the date in that cell instead of a name ? It gives an error if the value of the cell is a date
wow......❤
you row 11 is showing the wrong color indicator, it should be yellow but it is showing red
No it didn’t work
Please give me a link to download this file.
Can you help me in solving my query related to this , how to contact
I hate how business majors use excel and think they’re helping by posting “select this, now press make graph”
how to coding if next data will input on above data before on sheet ? pls your advice
Easy to follow thank you
Great titorial
Thank you - not sure why I am getting Complie error: Variable not defined error on Lastrow = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row Private Sub CommandButton1_Click() Dim product_id As String product_id = Trim(TextBox1.Text) Lastrow = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To Lastrow If Worksheets(Sheet1).Cells(i, 1) = product_id Then TextBox2.Text = Worksheets(Sheet1).Cells(i, 2).Value TextBox3.Text = Worksheets(Sheet1).Cells(i, 3).Value TextBox4.Text = Worksheets(Sheet1).Cells(i, 4).Value End If Next End Sub
its worl fine, thanks
Thanks a lot Dada
Thank you
Thank you.
Need code to delete only if the whole row is empty not cell
can i do this macro changing the copy with the function “cut”?
I love you man. Thank you so much for uploading this Keep up the good work
Can I write a formula for all the excel sheets in a folder as well? The sheets have different number of columns. How to go about it?
Thank you❤
Hi! How can i loop this macro onto other sheets? Thank you in advance :)
Dude...what's wrong with that Keyboard, put some oil on it or something...
Thanks, you are the best ❣️
Really Very Helpfull, i have one question, if 2 word in line then show error. Pls help...
Thanks