Welcome

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
    Else
    open frmInputData for input
    End if

    Thanks
    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)
    
    myErrorHandler:
    If Err.Number = 1004 Then
    UserForm2.Show
    Else
    UserForm1.Show
    End If
    End Sub
    
  3. That is very interesting, You are an excessively professional blogger. I’ve joined your feed and look forward to in quest of more of your fantastic post. Also, I’ve shared your site in my social networks!

Leave a Reply

Your email address will not be published. Required fields are marked *