Skip to main content

VISUAL BASIC FOR APPLICATION

 Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language




VBA helps to automate many functions which increase your productivity in work and save a lots of time
if u get irritated by doing same work in excel sheet . if you doing same repetitive process daily.
give so much time in that process.Then you need learn VBA. 

I feel bored doing office work , so much repetitive process, such as highlight , copy ,paste, data extraction , sometime i hated my work . then i learned VBA in lockdown duration. Now i loved my work and my productivity increase and save a lots of time

for example
  • If you want to save each sheet as new workbook, it easy if you have 2-3 worksheet , but if you have 50-60 worksheet then it took lots of time and  you get exhausted and  you hate your job.
  • if you copy 10-20 workbook data in single sheet and in every workbook data column sequence different. just imagine the time it took.
  • if you unhide the 15 sheet in workbook
you are not machine ,who only doing repetitive process daily.

just learn it . 



Labels:

Comments

  1. High Technologies Solutions10 February 2021 at 04:45

    Enjoyed reading the article above, really explains everything in detail, the article is very interesting and effective.

    Advanced Excel Training Institute in Delhi

    ReplyDelete

Post a Comment

Popular posts from this blog

GSTR 1 CDNR sheet Editing

You spent lots of time in structuring the CDNR sheet for future working. It easy for 1 time, took more time if you have 2 sheets but if you have more than 5 sheets then this trick helps you in time-saving and from machine work. It simple and easy  Here are the steps : Press ALT +F11 insert new module copy the code and paste in module Sub vir() Application.ScreenUpdating =false     Rows("1:4").Select     Range("O1").Activate     Selection.Delete Shift:=xlUp     ActiveSheet.Shapes.Range(Array("Picture 1")).Select     Selection.Delete     Range("C1:F1").Select     Selection.ClearContents     Range("J1:M1").Select     Selection.ClearContents     Range("A1:A2").Select     With Selection         .HorizontalAlignment = xlGeneral         .VerticalAlignment = xlCenter         .WrapText = True         .Or...
1 comment
Read more

Excel Shortcut Keys

Everyone wants speed in every work, to get speed in excel you used shortcuts for different operations, which is very useful in saving time ,you become a speeder in excel ,that save lots of time Close a workbook Ctrl+W Open a workbook Ctrl+O Go to the  Home  tab Alt+H Save a workbook Ctrl+S Copy Ctrl+C Paste Ctrl+V Undo Ctrl+Z Remove cell contents Delete Choose a fill color Alt+H, H Cut Ctrl+X Go to  Insert  tab Alt+N Bold Ctrl+B Center align cell contents Alt+H, A, C Go to  Page Layout  tab Alt+P Go to  Data  tab Alt+A Go to  View  tab Alt+W Open context menu Shift+F10, o...
Post a Comment
Read more

autofit rows and column in excel vba

Everytime we copy the data  and paste in new sheet , it get unfit . Some data unvisible and Column are not unfit .we require to column auto resize  method 1 press  CTRL + A  then press Alt then button H then button O then button I it easy but if you have many sheet method 2 copy it on module Sub autofit ()  Rows. Entirerow. Autofit Columns. Entirecolumn. Autofit  End sub
1 comment
Read more