About Us

Welcome

I am Someswari D, 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…

I would like to especially thank my husband for allowing me to spend many of my days & nights for writing articles, and improve around with sharing knowledge and new ideas. Without his great support VBAF1.COM not there. Thanks for all your support, understating.

Useful Resources:

Click on the following links of the useful resources. These helps to learn and gain more knowledge.

VBA Tutorial VBA Functions List VBA Arrays in Excel Blog

VBA Editor Keyboard Shortcut Keys List VBA Interview Questions & Answers

3 thoughts on “About Us”

  1. Raghu Prabhu

    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. Halady Prabhu

    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. PRADEEP KUMAR

    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.
    THANK YOU VERY MUCH.

Leave a Reply