MIS-Interview Series-Q4
MIS-Interview Series-Q4 Question was asked in MIS Interview. https://youtu.be/JSYopkuDKA8
Read moreTag: MAKE FOLDER WITH EXCEL VBA
MKDIR Function in Excel Vba
MKDIR In excel vba we use MKDIR vba function to create folder. MKDIR Function का उपयोग हम excel vba में folder बनाने के लिए करते है. I have to make a folder in D Drive which name will be computer. For this we have type code हमें D drive में एक फोल्डर बनाना है जिसका नाम COMPUTER होगा. इसके लिए हमें यह कोड लिखना होगा. Sub MakeFolder() MkDir “D:\COMPUTER” End Sub This Code will make folder in D Drive. यह […]
Read moreMatch_Function
MATCH Function in Excel एक्सेल में मैच फंक्शन का प्रयोग With the help of match function we find out position of a lookup value in a row or column. It does not return the value. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. We often use match with Index and Vlookup for getting data. It can be used with text and numbers. This function looks for an item in a list and shows its position. […]
Read moreMake 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 moreActiveX 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 moreExtract Last Name from A Cell Value
Dear All, From this video you can learn how to extract last word from a Cell in Excel.
Read more