I am Someswari (Somu), A passionate VBA Developer, having more than 8 years of experience in VBA Application Development. I learnt several key skills which make me satisfied in my life and continuing in learning new skills everyday. And this blog is my passion to learn new things and share my knowledge to make you an expert in the subjects (Excel, VBA, SQL) which required to analyse the data and fastening your processes by automating the tasks. Keep watching for more updates…

VBA Functions
VBA Functions are most important which are used while writing procedures or macros. We have list of VBA Functions. These functions are built in functions. We can also write user defined functions as per our requirements. We have different categories of functions. Each category has list of functions to deal with different type of data.

3 thoughts on “About”

  1. Hi I need some help for writing the VBA code to do the following:

    I have a workbook with two worksheets. One is to input data “Input Data” and other one to hold the details of the users “Users”. It has two forms “frmInputData” and “frmUsers”
    When the user opens the workbook,
    If the user is not in the “Users” then
    Open frmUsers, input the users details
    Save and close and open frmInputData
    open frmInputData for input
    End if

    Raghu Prabhu

  2. The following code can be used to capture and input the user details in sheet2 of the worksheet.

    Private Sub Workbook_Open()
    On Error GoTo myErrorHandler:
    Dim User_Name As String
    Dim myRange As Range
    Dim yesNo As Variant
    Set myRange = Sheet2.Range(“A:A”)
    User_Name = Environ(“username”)
    yesNo = Application.WorksheetFunction.VLookup(User_Name, myRange, 1, False)
    If Err.Number = 1004 Then
    End If
    End Sub
  3. Hi Somu,

    I am learning VBA from last one month. I joined in a online course. I has learned basics with that course, but it doesn’t not has detailed explanation. I found this site from google, It is very explanatory and easy to practice with examples. Your site is marvelous.

Leave a Reply