...

MS Excel VBA

POST

How to Create a School Management Systems in Excel VBA

Admission Form Fee receipt and other form like calendar expense income etc.. Download!How to Create a School Management Systems in Excel VBA Source Code Of Admission Form ‘=========================================================================== ‘Start Code for upload photo and this code will be always placed on top ‘=========================================================================== Dim fpath As String ‘============================================================================================================================= ‘Start code for select only from ComboBox […]

How to Create a School Management Systems in Excel VBA Read More »

Excel Dependent List Boxes In User form VBA

https://www.youtube.com/watch?v=EG3-5ZagRJ0 Excel Dependent List Boxes In User form VBA   we have defined dynamic names for 4 columns :    Supplier name refers to : =OFFSET(Data!$A$2,0,0,COUNTA(Data!$A:$A)-1) Category name refers to : =OFFSET(Data!$B$2,0,0,COUNTA(Data!$B:$B)-1) Product name refers to : =OFFSET(Data!$C$2,0,0,COUNTA(Data!$C:$C)-1)  Price name refers to : =OFFSET(Data!$D$2,0,0,COUNTA(Data!$D:$D)-1)   Download!Dependent List Boxes Sources code. ‘For More : msexcelvba.com Option Compare Text

Excel Dependent List Boxes In User form VBA Read More »

How To Separate Text And Numbers In Excel using VBA macros

How To Separate Text And Numbers In Excel using VBA macros

https://www.youtube.com/watch?v=ItPivGlJ-BI&t=121s How To Separate Text And Numbers In Excel using vba macros   Regular Expressions (Regno or Regtext) are frequently used in the developer world. They are used to validate website password information, search for text expression patterns, and many other uses. When using Regno in VBA, patterns are based. In our example file, column

How To Separate Text And Numbers In Excel using VBA macros Read More »

Phrase Data Into Sheets Excel VBA

https://www.youtube.com/watch?v=LBzt2QahpcE Phrase Data Into Sheets Excel VBA   Download!Phrase Data Into Sheets Excel VBA Private Sub Worksheet_Change(ByVal Target As Range) Dim A As Long If Target.Column = 8 Then For i = 5 To Me.Cells(Rows.Count, 1).End(xlUp).Row If Cells(i, “H”).Value = “Administration” Then Rows(i).Copy Sheets(“Administration”).Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues Rows(i).Delete i = i – 1 ElseIf Cells(i,

Phrase Data Into Sheets Excel VBA Read More »

Scroll to Top