![Excel Destination](/img/default-banner.jpg)
- Видео 312
- Просмотров 12 391 454
Excel Destination
Индия
Добавлен 10 ноя 2013
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 : EXCELDESTINATION@GMAIL.COM
Website : exceldestination.com/
Live Stream URL:
rtmp://b.rtmp.ruclips.net/user/live2?backup=1
rtmp://a.rtmp.ruclips.net/user/live2
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 : EXCELDESTINATION@GMAIL.COM
Website : exceldestination.com/
Live Stream URL:
rtmp://b.rtmp.ruclips.net/user/live2?backup=1
rtmp://a.rtmp.ruclips.net/user/live2
Excel VBA UserForm with Multiple Option Buttons - VBA Code for Option Buttons
This Advanced Userform Tutorial will explain how to use Multiple Option Buttons in UserForm and How to transfer data from UserForm to Sheet using Multiple Option Buttons.
VBA Code will Explain how to select multiple option choices from given Radio Buttons in UserForm and then transfer data from UserForm to worksheet as per selection.
Watch more UserForm Real Time Examples at below link :
ruclips.net/video/FnJ5sE0m_hg/видео.html
VBA Code will Explain how to select multiple option choices from given Radio Buttons in UserForm and then transfer data from UserForm to worksheet as per selection.
Watch more UserForm Real Time Examples at below link :
ruclips.net/video/FnJ5sE0m_hg/видео.html
Просмотров: 42 252
Видео
VBA to Get Color of Cell - Cell Background Color in Excel using ColorIndex
Просмотров 12 тыс.3 года назад
This Excel VBA Example explains VBA ColorIndex to Find Interior Color of Excel Cell. Macro to check background color, return background color and apply background color using ColorIndex in Excel.
Excel VBA to Delete Rows if Cell is Blank - Delete Rows Based on Cell Value - Code Included
Просмотров 20 тыс.3 года назад
This Excel VBA Tutorial explains VBA Code to delete rows when cell is blank. You can use For Loop with If Condition to write VBA code to delete rows based on cell value condition. VBA Code , used in this example is as follows : a = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To a If Worksheets("Sheet1").Cells(i, 3).Value = "" Then Rows(i).Delete End If Next
VBA to Move rows Automatically from one sheet to another - Excel VBA Macro Example
Просмотров 32 тыс.3 года назад
This Excel VBA Tutorial explains how to move entire row from one worksheet another worksheet based on cell value. We can move a row to any worksheet based on cell value. We can write code on SelectionChange event for this task.
Compare Data in Two Excel Sheets - Compare Two Worksheets Quickly
Просмотров 3,6 тыс.3 года назад
This Excel Tutorial explains, How to compare data in two excel sheets with simple formula. We can compare two data sets in 2 excel sheets using simple if formula. Formula used in tutorial is : =IF(Sheet1!B2=Sheet2!B2,"True","Sheet1 : "&Sheet1!B2&"Sheet2 : "&Sheet2!B2)
Excel VBA ComBox Box with AutoComplete Search - Excel VBA Searchable Combox - Code Included
Просмотров 64 тыс.3 года назад
This Excel VBA example explains how to create searchable ComboBox with autocomplete feature. you can get the relevant items as soon as you type in ComboBox and it autocomplete entries basis on matches. Code is as follows : Option Explicit Private Comb_Arrow As Boolean Private Sub ComboBox1_Change() Dim i As Long If Not Comb_Arrow Then With Me.ComboBox1 .List = Worksheets("Data").Range("A2", Wor...
VBA to Create New Workbook - Excel VBA Macro Example
Просмотров 14 тыс.3 года назад
This Excel VBA tutorial explains how to create a new workbook using VBA Code. You can also learn how to create new workbook and name it at a specific location.
VBA Save As File to Specific Location - Workbook Save as VBA Code Examples
Просмотров 88 тыс.3 года назад
VBA Save As File to Specific Location - Workbook Save as VBA Code Examples
Excel VBA to round off Numbers to nearest 10, 100, 1000, and rounding decimals to 2 places
Просмотров 11 тыс.3 года назад
Excel VBA to round off Numbers to nearest 10, 100, 1000, and rounding decimals to 2 places
Highlight Top 3, Top 5 and Top 10 Values using Conditional Formatting
Просмотров 18 тыс.3 года назад
Highlight Top 3, Top 5 and Top 10 Values using Conditional Formatting
Highlight Duplicate and Unique values using Conditional Formatting
Просмотров 5 тыс.3 года назад
Highlight Duplicate and Unique values using Conditional Formatting
Highlight Blank and Non Blank Cells using Conditional Formatting
Просмотров 10 тыс.3 года назад
Highlight Blank and Non Blank Cells using Conditional Formatting
Conditional Formatting to Highlight Odd and Even Numbers in a Range
Просмотров 13 тыс.3 года назад
Conditional Formatting to Highlight Odd and Even Numbers in a Range
VBA Code to Extract Text Between two Strings - Macro for Text Mining in Simple Steps
Просмотров 8 тыс.3 года назад
VBA Code to Extract Text Between two Strings - Macro for Text Mining in Simple Steps
VBA to Loop Through Files in a Folder - Excel VBA Macros example
Просмотров 6 тыс.3 года назад
VBA to Loop Through Files in a Folder - Excel VBA Macros example
Excel VBA Code to Create Chart - Charts Automation Example
Просмотров 19 тыс.3 года назад
Excel VBA Code to Create Chart - Charts Automation Example
IF with OR Function to Check Multiple Conditions - Excel Formula
Просмотров 6 тыс.3 года назад
IF with OR Function to Check Multiple Conditions - Excel Formula
IF Statement to Check IF a Cell is Blank or Non Blank
Просмотров 9 тыс.3 года назад
IF Statement to Check IF a Cell is Blank or Non Blank
IF Statement to Check if a Date is Between Two Dates
Просмотров 24 тыс.3 года назад
IF Statement to Check if a Date is Between Two Dates
Excel Nested If Function with Multiple Text and Number Conditions
Просмотров 45 тыс.3 года назад
Excel Nested If Function with Multiple Text and Number Conditions
IF Function with Vlookup in Excel - Excel Formula Example
Просмотров 72 тыс.3 года назад
IF Function with Vlookup in Excel - Excel Formula Example
Excel IF AND Function with Multiple Criteria - Excel Formula Tutorial
Просмотров 22 тыс.3 года назад
Excel IF AND Function with Multiple Criteria - Excel Formula Tutorial
Excel VBA UserForm to Avoid Duplicate Entries while Transferring Data to Excel Worksheet
Просмотров 20 тыс.3 года назад
Excel VBA UserForm to Avoid Duplicate Entries while Transferring Data to Excel Worksheet
Excel VBA to Export Range as Image - VBA Coding to Export Image
Просмотров 24 тыс.3 года назад
Excel VBA to Export Range as Image - VBA Coding to Export Image
VBA to Extract File Name and File extension from File Path - Get File Information in Excel
Просмотров 13 тыс.3 года назад
VBA to Extract File Name and File extension from File Path - Get File Information in Excel
Autofit UserForm in Excel VBA - UserForm Example
Просмотров 19 тыс.3 года назад
Autofit UserForm in Excel VBA - UserForm Example
VBA to Set a Cell Comment, Delete Comment and Add Comments in multiple Cells based on Condition
Просмотров 5 тыс.3 года назад
VBA to Set a Cell Comment, Delete Comment and Add Comments in multiple Cells based on Condition
VBA to Convert Table to Range - Excel VBA Example
Просмотров 12 тыс.3 года назад
VBA to Convert Table to Range - Excel VBA Example
Data Validation in Excel VBA - VBA Code to Validate Data Entry
Просмотров 21 тыс.3 года назад
Data Validation in Excel VBA - VBA Code to Validate Data Entry
Excel VBA Code for Renaming All Files in a Folder - Excel VBA FSO
Просмотров 32 тыс.3 года назад
Excel VBA Code for Renaming All Files in a Folder - Excel VBA FSO
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
Very helpful, Sir. Watching from Ghana
Vire nice
damn !! who ever found this video would be blessing you brother <3