Make Watch in Excel VBA use of ONTIME Function

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 more

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