Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Thanks for reply Daniel. What I mean is when I start a function in Excel, e.g. VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), I see the arguments after typing =VLOOKUP(. Another (maybe better) examples are: SUMIF(range, criteria, [sum_range]) where you first have to select the range for the criteria and by using SUMIFS(sum_range, criteria_range1, criteria1, ...) you first need to select the range for your sum. A lot of Excel users aren't aware of these very helpfull tips
Thanks for the excellent videos. I watched the one about about if-then-else statements while half asleep and the next day I was able to write my first working script! It was like it just came to me in a dream lol
I believe if you have option explicit, you would then have to declare all variables up front. So any objects being set or variables would need to be declared before use. Dim blah as Variant Dim myNumber as Double etc. . .
Hi Daniel, Thanks for coming back. After creating a function in VBA (used your vlookup example #12) and testing, I don't see the screentip after the (. My function is called "Artikel". So in Excel I start with =Artikel( and after that, nothing appears in the screen. It does when I use the build-in function. Maybe a setting? BTW: I'm working with the Dutch version.
Another issue for example is that when I create a temporary macro in a new workbook, a new workbook really opens and i have to switch back to the original workbook I'm working in. In my daily job I'm working with the Englisch version and don't have that problem :) So it's probably a setting or a bug in the dutch version. Or could it be the difference between V2010 (work) or V2013 (home)? I will figure it out the next couple of weeks.
Hi, needed help here... I actually have 1 excel workbook with multiple sheets. On sheet 1, I have certain names (A,B,C) and based on those names I have created the additional spreadsheets with names (A,B,C). Now I am back at sheet 1. Now I have a folder in my system where in I have 3 Excel with Name (A,B,C) with data only on sheet 1. I want to now pull the data in those 3 excel sheets to this main excel and to each sheet A B & C respectively. Can you please advice how I can perform this action? Thanks, Manish
Dude, let me ask u something. If i want to color the cell's backgound according to some value, like if C5.value = 5 then (red) or C6.value = 6 then (blue). what are the classes and properties envolved to do as such ?? ty
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
well said sir.
I learned a lot from you!...Merry christmas to you too.
Great video!
Thanks for reply Daniel. What I mean is when I start a function in Excel, e.g. VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), I see the arguments after typing =VLOOKUP(. Another (maybe better) examples are:
SUMIF(range, criteria, [sum_range]) where you first have to select the range for the criteria and by using
SUMIFS(sum_range, criteria_range1, criteria1, ...) you first need to select the range for your sum.
A lot of Excel users aren't aware of these very helpfull tips
Thank you! I'm here in 2019 and I have not found much on this topic until I found your video.
Really well explained👌
One million times thank you! This seems simple but it helped me a lot in my current project!
Thanks.... It's very useful video.....👍🏻
Brother thanks a ton 🙃🙃🙃🙃
Small small problem troubles a lot and you helped in solving that
Thanks for the excellent videos. I watched the one about about if-then-else statements while half asleep and the next day I was able to write my first working script! It was like it just came to me in a dream lol
WHAT A GREAT VIDEO. Like what you said, this is really good stuff!
Thank you for these videos, great resource.
I believe if you have option explicit, you would then have to declare all variables up front. So any objects being set or variables would need to be declared before use. Dim blah as Variant
Dim myNumber as Double
etc. . .
Another great explanation. Thanks.
Is there a trick to see also the screentips as you get when you use the "normal' functions within a worksheet?
Hmmm, not sure what you mean. Normal function screentips? Please explain. Thanks Jan!!
Great!
Hmmm. Usually when I do a worksheet function within VBA or worksheet it shows these. When does it not display the screentips for you, Jan?
Great lesson
Hi Daniel, Thanks for coming back.
After creating a function in VBA (used your vlookup example #12) and testing, I don't see the screentip after the (.
My function is called "Artikel". So in Excel I start with =Artikel( and after that, nothing appears in the screen. It does when I use the build-in function.
Maybe a setting? BTW: I'm working with the Dutch version.
Hi Daniel. Great lesson. Would there need to be changes with these VBA commands if you're working in option explicit?
Thanks a lot. It really helped me out.
Great video.
What's best way to activate workbook called "sales" if it is already open, or if it's not open then open it?
How do I activate a book in MHTML format?
Another issue for example is that when I create a temporary macro in a new workbook, a new workbook really opens and i have to switch back to the original workbook I'm working in.
In my daily job I'm working with the Englisch version and don't have that problem :)
So it's probably a setting or a bug in the dutch version.
Or could it be the difference between V2010 (work) or V2013 (home)?
I will figure it out the next couple of weeks.
Hi, needed help here... I actually have 1 excel workbook with multiple sheets. On sheet 1, I have certain names (A,B,C) and based on those names I have created the additional spreadsheets with names (A,B,C). Now I am back at sheet 1. Now I have a folder in my system where in I have 3 Excel with Name (A,B,C) with data only on sheet 1. I want to now pull the data in those 3 excel sheets to this main excel and to each sheet A B & C respectively. Can you please advice how I can perform this action?
Thanks,
Manish
Cool stuff! Thankyou :)))
Great video! Thanks Daniel. I got your udemy course ;)
how to work enabled this with screeenupdating
Dude, let me ask u something. If i want to color the cell's backgound according to some value, like if C5.value = 5 then (red) or C6.value = 6 then (blue). what are the classes and properties envolved to do as such ??
ty
Check this one out or try conditional formatting. Here's the link: Excel VBA Tips n Tricks #28 Rotate Color of Cell each time you Click User Q n A
hi
it is possibe to switch between 2 sheets with timer
like to go to the next sheets after 30 sec and go back after 30 seconds
with life time loops?
Shahar Levi I would think so.
Maybe with a DO Until statement. but these are prone to locking things up. hmmm.
Dan
hello sir i want to activate a workbook through path capture in another workbook
Hi Arshi,
Something like this, perhaps:
WorkBooks("C:\myFolder\myBook123.xlsx").Activate
Thanks
Dan