Tag: ADVANCE EXCEL FORMULA

VBA Leave a comment

ActiveX Controls In Excel with VBA Code

Dear All, From this video you can learn use of Check Box Option Button Label Command Button Group Box Download Excel From Here Below Code has been used. Private Sub CommandButton1_Click() If TextBox1.Value = “” Or Len(TextBox1.Value) < 5 Then TextBox1.Value = “” Exit Sub End If If Range(“j5000”).End(xlUp).Value = “Roll” Then Range(“j5000”).End(xlUp).Offset(1, 0).Value = 1 Else Range(“j5000”).End(xlUp).Offset(1, 0).Value = Range(“j5000”).End(xlUp).Value + 1 End If TX = TextBox1.Value Range(“j5000”).End(xlUp).Offset(0, 1).Value = UCase(TX) If OptionButton1.Value = True Then op1 = OptionButton1.Caption […]

Read more
MATHS Leave a comment

SUMIF Function in Excel

SUMIF   With the help of SUMIF Function in excel we get total value of all numbers in a range of cells based on one criteria. SUMIF की मदद से हम एक्सेल में, किसी range में से एक criteria के base पर, नंबर का टोटल निकलते है. For example in below image, we have item name & their value. उदाहरण के लिए, निचे के image में, item का नाम और valueहै. I want to sum of all value which is […]

Read more
VBA/Macro Leave a comment

Use of Len Function in Excel Vba Macro

LEN In excel vba we use LEN Function to count number of character is used in any supplied string and we store it at supplied variable.   Excel vba में हम Len Function का प्रयोग किसी String या Cell में मौजूद value का length जानने के लिए करते है कि यहाँ कितने character use हुआ है और उसे हम एक variable पर store करते है.   Example 1:- Sub LEN1() Dim LN As Integer LN = Len(“COMPUTER”) End Sub In […]

Read more