VBA if else statement with multiple conditions - Excel VBA
HTML-код
- Опубликовано: 6 окт 2024
- This tutorial explains IF Elseif Else Statement in Excel VBA with simple example. We can use IF ElseIF Statement with multiple conditions in VBA programming.
How to use these conditions on time? For example if work done within certain time it should "Met" and if not done within time line it should show "Not met"
thank for your comment.
you can take help from following tutorial :
ruclips.net/video/VmtEM5-RkQY/видео.html
This is super nice!!!
Thank you!!
Thanks bro...
Great sir you genious
Thanks Sandeep!
if in a case the value of A1= A2=A3=A4= till A ActiveSheet.UsedRange then add the G1+G2 upto G ActiveSheet.UsedRange can be possible write a VBA code to check this condition . Request for answer on my mail ID pls
And make the condition from cell row 5 until row 30 colom 3 and colom 4
Thank you.
But how to use else if , if in multiple ledger transforming to their concern destination worksheet.
for any specific vba code, you can write to exceldestination@gmail.com
@@ExcelDestination ok I will submit my file with the problems in details and for a possible solutions; to this id tomorrow and I am hopeful that the same will be resolved by you. Thank u for replying thank u so much. I am really glad .
@@ExcelDestination what happened about the coding of my email file . plz break the silence
@@ExcelDestination Coding for extracting data from data base between any two different dates
While run Show Compile error wrong number of arguments or invalid property assignment
My Date is under column 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61
plz correct the code
Private Sub CommandButton1_Click()
Dim i As Long
Dim x As Integer
Sheet5.Range("A" & 2, "M" & 50000).ClearContents
For i = 3 To Sheet1.Range("B100000").End(xlUp).Row
If Sheet1.Cells(i, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61) >= CDate(Me.TextBox1) And _
Sheet1.Cells(i, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61)
How about 5 condition? Please give me solution
Thank....👍👍👍👍👍
Thanks ... Thanks.
Nice
thanks