Want to be an expert in Excel-Macro

Dear Friends,

Do you want to be an expert in Excel - Macros.

Steps to be followed:

First we have to understand how the Excel works when we give inputs thru Keyboard or mouse.

If we can easily understand the same, we can write 'n' number of macros without the help of VB.

I accept that we have to use VB Code in Macro, but Concepts are much more important than the VB Codes.

Follow the given steps to get a clear idea:

Step 1: Record a new MACRO
Step 2: Select A10, Type "CACLUBINDIA"
Step 3: Stop the MACRO
Step 4: Go to Visual Basic Editor.
Step 5: Read how System has written codes in your macro.

You can understand the codes what system has written in macro. Just try the same with some other Functions. (like set print area, delete sheet....etc)

You can be an expert in macro, if you understand the concept without having Coding Knowledge in VB.

I think i will be helpful to you... please reply and give suggestions...

I m Ravi Mehta. I read your message its fine but i m not able to still got clear idea on what to do after stop macro. Plz. give me proper idea so i can get my work faster. Thanks in advance

Dear Mr. Ravi.

After that (Stop Macro), press Alt+F11, it will get you to VB Editor window.

You can find Project - VBProject Window.
In that window, Module1 will be available.
Double Click it.

You can find the codes in the middle window.

I got your reply. Thanks You. I got the module which seems that Sub Macro1() ' ' Macro1 Macro ' Macro recorded 12/19/2007 by RAVI ' ' Range("A10").Select ActiveCell.FormulaR1C1 = "caclubindia" Range("C15").Select End Sub Now what i have to do for repeat this steps. Thaks for your solution Hope fast reply from you. Thanks.

Hi ravi

when ever u run his macro u would be entering the word "caclubindia" in cell A10 and will move to cell C15.

u can try nd experiment with it by replacing the lines
Range("A10").Select
ActiveCell.FormulaR1C1 = "caclubindia"
Range("C15").Select

with

ActiveCell.FormulaR1C1 = "caclubindia"

Dear Mr. Ravi,

Now you know the VB codes:
1. to select a cell (i.e Range("A10").Select)
2. to Enter value in cells (i.e. ActiveCell.FormulaR1C1="Caclubindia")

The same way u just run a macro to change Cell background color, font color and font size.

Then read the codes as, how EXCEL has written Macro to do the particular action.

You can easily get/understand those kind of codes also...

The same way, record macros and learn VB Codes. One fine day, you will come to know all basic kind of codings to develop your own Macros without Excel/VB Help.

Hi,

I want to know what are Macros used for??

 

Yaar but it's not easy i think so....but i have already taken lots of help from this practice........

Dear Kamraj, I want to be expert in excel. for that i want ot learn VB . can u guide me on line or refer some books.

Can I learn the VB without any coaching classes or without any help of any teacher.