Quickly learn how to work with Excel VBA IF, THEN, ELSE, ELSEIF, AND statements. This way you can write Excel macros that are dependent on multiple conditions.
We take a look at looping through a set range of cells in an Excel table, checking their value and then changing the cell color based on that value.
In addition to learning the IF THEN statement and how to loop through cells, you also learn how to quickly get the color code of a specific cell so you can refer to it in your Excel macro. I’ll show you a trick with the immediate window and how you can test, and query code in there.
🡻 Download the workbook here 🡻
★ Links to related videos: ★
FOR EACH VBA:
IF THEN in Excel Formulas:
VBA Playlist:
★★ My Online Excel Courses including VBA ★★
Courses ►
🕮 Excel Resources I Recommend 🕮
✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
#ExcelVBA
Nguồn: https://habblezhotel.net/
Xem thêm bài viết khác: https://habblezhotel.net/category/cong-nghe/
shah faisal says:
Mam Good Morning, can you please upload a video on command button, I want to know how to use one command button for two function. I mean if i am working on Form so if there is data so the same command button updates otherwise add as new entry. waiting for you kind response.
Shahab Ali (shahabaliktk@gamil.com)
mimi cba11 says:
Thank you ….. was clear !!!
Bryan Awkwardson says:
Wow…you´re very skilled at this and explaining it in a way so it´s easy to understand.
I A says:
Excellent,
Tim Wills says:
Excellent! Clear, to the point, and easy to understand…… Just what I needed 🙂
tw04l124 says:
bad example, as no one will name by hand a table, it needs to be done in code, not by hand.
vijay sahal says:
hii madam really so gud ur if statement in vba m loving it
VIRIBUS GYM says:
hello, i have some issue in my profit report, i want to make a day by day profit report, can you helpy me ?
Thank you
sri suresh M says:
Good one
Lawrence MG says:
many thanks,
szimeon bojos says:
hello leila your tutorial is really awesome!! btw can i use excel formulas in VBA?
Lewis says:
…Gracias
parlindungan sitanggang says:
cool! thanks..
saj1507 says:
perfect explanation in simplest manner.
edi black says:
This was awesome and really helpfull, Thank you.
Philip Clarke says:
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
Md. Mahbub Rahman says:
Really pleased to watch & learn new thinks.
Md. Mahbub Rahman says:
Really pleased to watch & learn new thinks.
Indira Yimsomboon says:
Have you got video how to calculate tax on tax using Excel?
Samuel prosper says:
Amazing.
Thanks for the knowledge shared on VBA!!
Christopher Sly says:
One of the best instructors on the topic of VBA…huge thanks!!!
André Niquet says:
Great video again … I LOVE the trick you showed on 8:46 …. very handy …thanks for everything
Tarun Jain says:
Very Good and Quick explanation, Thanks Ms Gharani. Are you Indian?