I remember telling you that I cant understand VBA and today just because of you I am able to create logical templates using vba...Thanks Leila! I cud never have Guru like you!
Well, you’ve done it again: I’ve never seen the Immediate window used to find a colour. Obvious really but so is everything once somebody has shown you the trick. Many thanks. 👍🏻🙄
Awesome, I learned three things I didn't already know. (I already knew how to do IF in VBA :) 1. vba.colorconstants (my new favourite code) 2. query a cell colour from the Immediate Window (so very very cool) 3. elseif (gonna have fun playing with that one!) I am one of a very small group of Excel gurus (3 of us) in my workplace, I spend a lot of time trying to explain Excel to people who don't even know how to hide gridlines (urrrrgh).... now I just send them to your UA-cam Channel and tell them to come see me if they still can't do what they want! BEST TUTORIAL VIDEOS EVER FOR EXCEL!!! Cheers, -Byron
every day, when i have a problem with excell, your videos helps me a lot. for example, you solved my last, and i won a beer :D THX Leila You are the best
Absolutely awesome tutorial, aggretating valuable tricks in most clear, concise and coherent fashion. Just wondering if using named range wouldnt be straitforward referencing the range than getting the synthax of the table column. Just learning and falling in love with xls out of your tutorials along with other top excel talented brilhant minds who are truly committed to unveil the power of Excel just like excellisfun and teachexcel.
Thanks! Leila that's really useful video in the context of VBA...appreciate your efforts a lot which really help us to learn excel quite easily. I always eagerly waiting for your video coz it always has something new to learn...i am excited about VBA will wait more video on VBA. Thanks a lot.👏👏👍👍☺
Thank you Ajay! Optimally I'd love to be able to upload 2 videos per week. 1 for VBA and the other Excel. But unfortunately I can't find the time for that (yet)...so for now I'll try to get in one a month. Thank you for your support.
Hi Leila, really like your videos about VBA. Excessing your videos from Papua New Guinea. My Question. I am trying to load tags to PI Process Book (PI SMT) but couldn't. Could you please show some light on this? Would really appreciate that.
Clean and helpful video, but I've found referencing cells on different sheets somewhat of a nightmare recently. It would be great if guides provided a full reference to the cells being manipulated without Activating the desired sheet.
@ Leila Gharani, Thank you very much for your very helpful video. If I what this VBA codes to work automatically while the data are entered in the table what needs to be done?
Leila Gharani is the online course going to be updated anytime soon? In an app crazy world, I just want to make sure it doesn’t get upgraded after I would purchase.
HI Leiia, I really like your approach on this. This video isn't part of the course, an addition to it. I think it would be cool if you could have future VBA videos on obscure macros that you couldn't find on many websites. Chip Pearson has a lot of code on his site, I wonder if there are others that have code that could really be complex - like the ones you helped me with while I was at CTA earlier in the year. That macro was quite masterful and really cool. All the Best, Michael
Hi Michael - Thank you! I revised it for UA-cam. I brought in different concepts from different lectures to one video. It's a good idea to show similar macros like the CTA one - actually I included the code I sent for that one in the VBA course.
♥♥ Hope you're doing well! .... Here two suggestions: * Other way for choosing color, from Home Menu 'Fill Color > More Color > Custom' and take values of RGB * it will be good if we put 'With' statement: For Each cell In Range("TableSa.... With cell.Interior If cell > 0 And.... .Color = RGB(226, 107, 10) ElseIf ..... .Color ...... Else .Color ...... End If End With Next
You're very welcome Leila, by the way , I have some ideas, if you want to produce them in Videos, I will send you lectures with details and you can produce them by your own way, if you agree let me know. your email is info@xelplus.com ?
Hello there. Not sure whether this is the correct platform to ask this question, however was not able to find the video about the question which I'm going to ask. I'm trying to create a tracker on excel using VBA, which captures the "START TIME" and "END TIME" of a specific task. The tracker is almost complete. The only thing where I'm getting stuck is on the message box command. Suppose, there are 2 buttons "START TIME" & "END TIME". Obviously if you click on "START TIME" Marcos will record the current time and when you click on "END TIME" macros will end the task, record the time and will give the difference between the 2 times recorded. If without clicking on the "START TIME" button someone clicks on "END TIME", they will get a message box which says "Task Not Started". However, if a task is already started and ongoing and instead of clicking on "END TIME" to stop the task, the person clicks on "START TIME" again, it starts a new task and the old one doesn't end. To stop it, we'll have to click on START TIME twice, so that it can end the previous task and also the new one which started. If you could help me with the VBA Coding where in I'll be able to get a message box which says "End Previous Task", if someone clicks on "START TIME' again instead of clicking on "END TIME" to stop the ongoing task. Or copy the url of the video if you already have discussed this on any of your videos Thanks
I use an spreadsheet to estimate jobs. I want to produce a PDF summary report from the spreadsheet data. Spreadsheet Column 1 is “Category” (eg: Building, Painting), Column 2 is “Description”, Column 6 is “Value”. The logic is to copy each row where Value is greater than zero (hide all other rows) and copy to new worksheet. Then print a PDF report grouping each category together and calculate the sub total for each category and with a grand total. I also want to auto size the rows and remove any blank rows and columns from the PDF report so I don't get multiple empty pages. Many thanks, Phil Category Description Value Building Build walls $200.00 Building Fix linings $300.00 Building Patch $400.00 Building Subtotal $900.00 Painting Paint walls $450.00 Painting Paint ceiling $250.00 Painting Paint doors $150.00 Painting Subtotal $850.00 Proposal Total $1,750.00
Hello Leila, I do have a question here, i'm trying to create a formula or condition like this " If cell A start with letter " F " then cell B should start with letter " K " else " ERRORR ". Do you have any idea how can i do that ? Thank you.
Hi Leila, Thank you for the tutorial. I'd like to ask you another question. How do you ask Excel to look for a month and start a sequence function at the month? I want a number to appear in every other column 6 times and start at the month I asked, for example. I am able to get the number to appear every other month 6 times using the sequence function, but I need help to get it to start at the month I want. If I drag my current formula across the column, it will interfere with the sequence function. Many thanks! Sharon
Good after noon Madam, What would be the formula if i have to loop across the the row rather than down the column. Still you using the formula of "if and" here is my case i have the following formula: Sheets("Progress").Select Dim e As Double e = 5 For Each cell In Range("aB5:ku40") If cell.Value = Cells(e, 28).Value Then Cells(e, 28).Value = (Cells(e, 1))
Else Cells(e, 28).Value = ""
End If e = e + 1 Next cell i want the formula to run throught row than the Column.
Hi Leila, could you please help me? I have a spreadsheet where I have a drop down menu in column B and If the user selects ‘operator1’ or ‘operator2’ i would like multiple cells (F-L, Z-AC, AF-AM & Az) on the same row to be populated with ‘N/A’
Hello, I hope you are well. I have a question that I can not find the answer and I hope you can help. In your example "For x = 1 to 10". What if I wanted to be able to change the " 10 " element But from the excel main sheet1. I am thinking like I would enter a value in a cell and the loop would run that many times. Or maybe a pull down or something. My for x = 1 to ??? will change and I would like to not open the editor every time. Just entering it on the sheet somehow would be helpful. Any suggestions? Thank you
Need help with vba. Have Employee names in Column A, have date & time stamps in column B, have Entry or exit written in column C. Need a code that will calculate the actual time in office which is total time minus sum of all breaks. There are multiple entries and exits in one day for each employee. They also work overnight.
Awesome Video... And Nice Learning.... Do you have video for the below mentioned reason 1. Multiple If's and Else If's - with a validation sub 2. If any of the if's fail, it shouldn't call another macro that I have 3. All the errors needs to be corrected, before it calls another macro Please help!
Hi Leila Nice video do you ha some examples using a command or function like do while [condition] or loop to be interrupted by pressing specific key or button? If you do it will be very appreciated if you share have a nice day😍😍
Need help with vba. Have Employee names in Column A, have date & time stamps in column B, have Entry or exit written in column C. Need a code that will calculate the actual time in office which is total time minus sum of all breaks
Grab the file I used in the video from here 👉 pages.xelplus.com/vba-if-file
The G.O.A.T online teacher. Thank you, Leila.
I remember telling you that I cant understand VBA and today just because of you I am able to create logical templates using vba...Thanks Leila! I cud never have Guru like you!
You make any VBA code look so simple. I've always learnt something new from your videos. Thanks
Finally, an actually good teacher!
So glad to have you with us online!
Well, you’ve done it again: I’ve never seen the Immediate window used to find a colour. Obvious really but so is everything once somebody has shown you the trick. Many thanks. 👍🏻🙄
Excellent. No words further to explain your presentation. Really MY EXCEL TEACHER IS A GENIUS. I AM VERY LUCKY TO SEE HER BLESSINGS IN EVERY VIDEO.
Thank you very much Gopala for the very kind words and for your support.
Awesome, I learned three things I didn't already know. (I already knew how to do IF in VBA :)
1. vba.colorconstants (my new favourite code)
2. query a cell colour from the Immediate Window (so very very cool)
3. elseif (gonna have fun playing with that one!)
I am one of a very small group of Excel gurus (3 of us) in my workplace, I spend a lot of time trying to explain Excel to people who don't even know how to hide gridlines (urrrrgh).... now I just send them to your UA-cam Channel and tell them to come see me if they still can't do what they want!
BEST TUTORIAL VIDEOS EVER FOR EXCEL!!!
Cheers,
-Byron
Thank you, your Excel VBA tutorial on IF THEN statements was clear, concise, and coherent.
One of the best instructors on the topic of VBA...huge thanks!!!
Wow, thank you for the compliment Christopher!
While an older video, the value is still top-tier and has what I needed! Keep up the great work Miss!
Thank you! Will do!
I really appreciate your way of explanations, as you cover up all possible questions in the subject. You are my favourite xls teacher .
Hats off to Leila gharani, very informative channel
That's so elegant. I really like working with VBA and the proper Excel tables as a reference.
Thank you! Agree - Excel table referencing does make things easier....
Love the classic Leila. Beautiful and smart. If only I knew half the stuff you make look so easy lady. Thank you.
Thank you, Dan! 😊
Gracious. Thank you. 2:47 in, and after an hour of searching the Internet, you helped me solve it in less than three. Boy.
Glad to help :)
every day, when i have a problem with excell, your videos helps me a lot. for example, you solved my last, and i won a beer :D THX Leila You are the best
Great to hear, Sándor!
Wow!..to say you are great in explanation, is an understatement!. This is by far, the best tutorial I have ever seen or heard!.Thank you very much!
Thank you very much for this VBA video, I learned a lot! I wish you received more views
Great video on ifs and for loops. I have always used vbyellow and other colors. Awesome way to choose more color options. I learned something new.
Thanks a lot, that was just what I needed. Saved my life.
Thanks, please don't stop!
perfect explanation in simplest manner.
Glad you like it.
I'm very huge fan of using vba 😍😍
👍
Very useful VBA code! Is it possible to put the condition of Range("B9").Value>0 and Range("B9").Value
Best understanding in IF statement in VBA with color coding.
Thanks. I really admire your ways to teach as I am able to replicate whatever you show in your videos. Thanks a lot.
Excellent! Clear, to the point, and easy to understand...... Just what I needed :)
I'm glad to hear that Tim.
@@LeilaGharani Subscribed. I'll be back for more :)
Really pleased to watch & learn new thinks.
I don't find anything to say better than thank you very much from all of my heart
Very insightful. I think you're a genius. keep the videos coming.
Yup - best instructor. Thank you for this video!
Wow, thanks!
Absolutely awesome tutorial, aggretating valuable tricks in most clear, concise and coherent fashion.
Just wondering if using named range wouldnt be straitforward referencing the range than getting the synthax of the table column.
Just learning and falling in love with xls out of your tutorials along with other top excel talented brilhant minds who are truly committed to unveil the power of Excel just like excellisfun and teachexcel.
Excellent work!
I like this method much better than conventional formatting rules.
This is really helpful thank!
Thank you so much for your very super educated videos and so clearly explained
GOAT indeed!!!
I agree with Mike Awesome. Especially liked the method you use to determine color numbers. Great tip.
Thanks! I'm glad you like that tip. That's saved me a lot of time figuring out the right color in the code.
Yes, it also opens up ALL color possibilities and not be restricted to vbgreen or vbred :)
Very well explained. It's a good idea to convert data set into table and use this in VBA code
Thanks. Agree - it makes range referencing a little easier...
Good job Leila. Thank you for sharing.
Hi Leila.. an excellent and informative tutorial, as always.. thanks and Thumbs up!
Thank you Wayne!
thank you maam for this very informative video. and by the way i bought 2 of your courses in UDEMY :D and now i'm in progress :D
Great video again ... I LOVE the trick you showed on 8:46 .... very handy ...thanks for everything
Wow. Leila. Wow this was brillant. Thanks!
I'm glad you like it Aleksandrs! Thanks for watching.
Wonderfull explanation ❤
You deserve a like
Thanks!
Hi Ms. Leila thank you so much i'm so sorry i know i missed 3 videos but I really was so busy. anyway thanks again for your videos.
No worries Ismail! Thanks for your support - anytime :)
Thanks! Leila that's really useful video in the context of VBA...appreciate your efforts a lot which really help us to learn excel quite easily. I always eagerly waiting for your video coz it always has something new to learn...i am excited about VBA will wait more video on VBA. Thanks a lot.👏👏👍👍☺
Thank you Ajay! Optimally I'd love to be able to upload 2 videos per week. 1 for VBA and the other Excel. But unfortunately I can't find the time for that (yet)...so for now I'll try to get in one a month. Thank you for your support.
Brilliant, thanks for making VBA "digestable" even for me ;-)
Thanks for the video. how to add a blinking to it. Plz advise. Thanks
Hi Leila, really like your videos about VBA. Excessing your videos from Papua New Guinea. My Question. I am trying to load tags to PI Process Book (PI SMT) but couldn't. Could you please show some light on this? Would really appreciate that.
Clean and helpful video, but I've found referencing cells on different sheets somewhat of a nightmare recently. It would be great if guides provided a full reference to the cells being manipulated without Activating the desired sheet.
Thank you ..... was clear !!!
I have learnt macro from you. I like it. But let me know how you get the numbers for colours??
@
Leila Gharani, Thank you very much for your very helpful video. If I what this VBA codes to work automatically while the data are entered in the table what needs to be done?
Amazing.
Thanks for the knowledge shared on VBA!!
You're very welcome Samuel!
Always informative, great info! Thanks for putting the excel language in "Plain English" :-)
You're welcome Mike. Thanks for watching :)
Leila Gharani is the online course going to be updated anytime soon? In an app crazy world, I just want to make sure it doesn’t get upgraded after I would purchase.
Great work. If I may ask for a VBA that changes cell color based on a specific text in a cell, not based on the cell value.
Amazing channel. Got me hooked, I'm learning a lot. Keep it up...
I'm glad you like the content here :)
you are the best
Excellent,
Good one
Love it. Thank you for explaining things so well
HI Leiia,
I really like your approach on this. This video isn't part of the course, an addition to it. I think it would be cool if you could have future VBA videos on obscure macros that you couldn't find on many websites. Chip Pearson has a lot of code on his site, I wonder if there are others that have code that could really be complex - like the ones you helped me with while I was at CTA earlier in the year. That macro was quite masterful and really cool.
All the Best,
Michael
Hi Michael - Thank you! I revised it for UA-cam. I brought in different concepts from different lectures to one video. It's a good idea to show similar macros like the CTA one - actually I included the code I sent for that one in the VBA course.
Really cool. I thought that import code in your course looked familiar though it has some minor tweaks to it. Look forward to m,ore videos.
Thanks a Lot
Dear Leila,
Nice video but what if i want to multiply 2 columns in a table with condition
♥♥ Hope you're doing well! .... Here two suggestions:
* Other way for choosing color, from Home Menu 'Fill Color > More Color > Custom' and take values of RGB
* it will be good if we put 'With' statement:
For Each cell In Range("TableSa....
With cell.Interior
If cell > 0 And....
.Color = RGB(226, 107, 10)
ElseIf .....
.Color ......
Else
.Color ......
End If
End With
Next
Thank you Assem. Agree - RGB is good too.
WITH is also a good addition. Thank you for watching.
You're very welcome Leila, by the way , I have some ideas, if you want to produce them in Videos, I will send you lectures with details and you can produce them by your own way, if you agree let me know. your email is info@xelplus.com ?
You are amazing! Saved my task for the day. +1 Sub
Thanks for the sub!
Thank You
Hello there. Not sure whether this is the correct platform to ask this question, however was not able to find the video about the question which I'm going to ask.
I'm trying to create a tracker on excel using VBA, which captures the "START TIME" and "END TIME" of a specific task.
The tracker is almost complete. The only thing where I'm getting stuck is on the message box command.
Suppose, there are 2 buttons "START TIME" & "END TIME". Obviously if you click on "START TIME" Marcos will record the current time and when you click on "END TIME" macros will end the task, record the time and will give the difference between the 2 times recorded. If without clicking on the "START TIME" button someone clicks on "END TIME", they will get a message box which says "Task Not Started".
However, if a task is already started and ongoing and instead of clicking on "END TIME" to stop the task, the person clicks on "START TIME" again, it starts a new task and the old one doesn't end. To stop it, we'll have to click on START TIME twice, so that it can end the previous task and also the new one which started.
If you could help me with the VBA Coding where in I'll be able to get a message box which says "End Previous Task", if someone clicks on "START TIME' again instead of clicking on "END TIME" to stop the ongoing task.
Or copy the url of the video if you already have discussed this on any of your videos
Thanks
I use an spreadsheet to estimate jobs. I want to produce a PDF summary report from the spreadsheet data. Spreadsheet Column 1 is “Category” (eg: Building, Painting), Column 2 is “Description”, Column 6 is “Value”. The logic is to copy each row where Value is greater than zero (hide all other rows) and copy to new worksheet. Then print a PDF report grouping each category together and calculate the sub total for each category and with a grand total. I also want to auto size the rows and remove any blank rows and columns from the PDF report so I don't get multiple empty pages. Many thanks, Phil
Category
Description
Value
Building
Build walls
$200.00
Building
Fix linings
$300.00
Building
Patch
$400.00
Building Subtotal
$900.00
Painting
Paint walls
$450.00
Painting
Paint ceiling
$250.00
Painting
Paint doors
$150.00
Painting Subtotal
$850.00
Proposal Total
$1,750.00
very nice
hii madam really so gud ur if statement in vba m loving it
I'm glad to hear that Vijay.
Hello Leila,
I do have a question here, i'm trying to create a formula or condition like this " If cell A start with letter " F " then cell B should start with letter " K " else " ERRORR ". Do you have any idea how can i do that ?
Thank you.
Hi Leila, Thank you for the tutorial. I'd like to ask you another question. How do you ask Excel to look for a month and start a sequence function at the month? I want a number to appear in every other column 6 times and start at the month I asked, for example. I am able to get the number to appear every other month 6 times using the sequence function, but I need help to get it to start at the month I want. If I drag my current formula across the column, it will interfere with the sequence function. Many thanks! Sharon
Great video! I am not entirely sure this is what I need but I need some assistance in a situation on Excel and I am wondering if you could help?
Good after noon Madam,
What would be the formula if i have to loop across the the row rather than down the column. Still you using the formula of "if and"
here is my case i have the following formula:
Sheets("Progress").Select
Dim e As Double
e = 5
For Each cell In Range("aB5:ku40")
If cell.Value = Cells(e, 28).Value Then
Cells(e, 28).Value = (Cells(e, 1))
Else
Cells(e, 28).Value = ""
End If
e = e + 1
Next cell
i want the formula to run throught row than the Column.
Hi Leila, could you please help me?
I have a spreadsheet where I have a drop down menu in column B and If the user selects ‘operator1’ or ‘operator2’ i would like multiple cells (F-L, Z-AC, AF-AM & Az) on the same row to be populated with ‘N/A’
¡Gracias!
Thank you!
This was awesome and really helpfull, Thank you.
You're very welcome. Glad you like it.
Nicely done
Thank you🙏
Thanks. It's great.
Hello, I hope you are well. I have a question that I can not find the answer and I hope you can help. In your example "For x = 1 to 10". What if I wanted to be able to change the " 10 " element But from the excel main sheet1. I am thinking like I would enter a value in a cell and the loop would run that many times. Or maybe a pull down or something. My for x = 1 to ??? will change and I would like to not open the editor every time. Just entering it on the sheet somehow would be helpful. Any suggestions? Thank you
Thanks mam 🙏🙏🙏🙏🙏🙏
My pleasure :)
Thank ya
thank you
i have a question. How do you apply this to copying and pasting of data from one sheet to another sheet
Have you got video how to calculate tax on tax using Excel?
I am waiting for this .. thank you ..
Need help with vba. Have Employee names in Column A, have date & time stamps in column B, have Entry or exit written in column C. Need a code that will calculate the actual time in office which is total time minus sum of all breaks. There are multiple entries and exits in one day for each employee. They also work overnight.
Awesome Video... And Nice Learning.... Do you have video for the below mentioned reason
1. Multiple If's and Else If's - with a validation sub
2. If any of the if's fail, it shouldn't call another macro that I have
3. All the errors needs to be corrected, before it calls another macro
Please help!
Thank you. I cover this in detail in my complete course. Not sure if I have a video on it here. Check out the VBA playlist.
thanks.
Hi Leila
Nice video do you ha some examples using a command or function like do while [condition] or loop to be interrupted by pressing specific key or button? If you do it will be very appreciated if you share have a nice day😍😍
what code for not accepting negative value.Thanks
I have a row with negative & Positive Values in Multiple Columns. How do I hide the Columns with Negative Values
VBA module doesn't come up for me. Also, I need to do this for a table with words, not letters.
Hi can you please tell me how to open a active X in Microsoft 2011 in mac
hello leila your tutorial is really awesome!! btw can i use excel formulas in VBA?
Need help with vba. Have Employee names in Column A, have date & time stamps in column B, have Entry or exit written in column C. Need a code that will calculate the actual time in office which is total time minus sum of all breaks