Making Watch In Excel Vba From below vba code & video you can learn how to make watch in excel vba use on ontime VBA Function. Click Here to Download File Sub makingwatch() Dim cancel As Boolean If Range(“k1”).Value = True Then Exit Sub Else snd = Second(Now) minute1 = Minute(Now) hour_a = Hour(Now) Sheet1.Shapes.Range(Array(“snd_2”)).Rotation = 6 * snd Sheet1.Shapes.Range(Array(“minute_1”)).Rotation = […]
Read moreDear 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 moreDear All, From this video you can learn use of AND & OR Function in MS Excel.
Read moreLEN 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 moreUCASE We use UCASE function in excel macro. With use of Ucase function we convert a string into upper case. We have “computer” value in A1 cell, I want that “computer” word will be converted in upper case like “COMPUTER” and will be pasted in A5 cell. For this we have to use Range(“A5”).Value=UCase(Range(“A1”).VALUE) UCASE Function का प्रयोग हम Excel Macro में करते है. UCASE का प्रयोग कर हम किसी string के letter को Upper case में convert […]
Read moreLEFT We can use left function in excel & macro both. With the help of left function we extract characters from left site of a cell value or string. हम Left Function का प्रयोग Excel & Macro दोनों में करते हैं. Left Function की मदद से हम किसी Cell की वैल्यू से Left side से characters निकाल सकते है. We have Computer value in Cell A1. We use Left(Range(“A1”).Value, 3) to pick 3 character from left side of A1 cell […]
Read more