Want to be an expert in Excel-Macro

whenever i export data from software my excel sheet convert to Right to left can anyone sugget me the remedie for this

Difficult to understand :-(

Hello friend its really nice do u have any file specifically shows the procedure in picture format

Hey,

Pls tell that hw do i generate a new serial no. in cell  G1.

And also teel me hw to get a msg window asking the user to select "YES" or "NO" or "CANCEL".

Also tell me is ther any e-book available on macros.

Pls do rply ASAP..

 

Thanx in advance

Dear Friends,

Greetings!

I have read through all the posts.

Recording a macro for repetitive task saves time. But if you have to harness the "real" power of Excel, you must know VBA.

As one of the friends has queried regarding an e-book or site for macro, you can have a long list of sites through search engines. But I strongly belive that Excel is a "Practical" subject. Reading gives you some insight, but if you have to be a novice, you do need a trainer, with a real life experience.

I am a freelance Corporate trainer in MS Excel 2003 and HR. My experience is that Excel is being used as a "Glorified Calculator" without actually harnessing the analytical, logical, scientific, statistical powers.

I already have posted a separte topic with the Excel Curriculum attached. It can be found at /forum/messages/2008/10/15167_learn_secrets_to_utilize_the_most_powerful_and_useful_excel.asp.

I can be contacted at 09225246821 or deepvibha @ gmail.com

Regards,

Deepak

Dear Ravi,

 
This is the code to display Yes/No/Cancel msg window.
 
Private Sub Worksheet_Activate()
MsgBox "Hello Guest, Welcome to my Worksheet...", vbYesNoCancel, "Hi...."
End Sub
 
Do the following steps to display VbYesNoCancel Msg window.
  1. Copy the Code given above.
  2. Go to Tools>Macro>Visual Basic Editor or press Alt+F11
  3. Select a worksheet (Where you want to display the msg window) from the Project-VBA Project Windows.
  4. Paste the code.
  5. Close the Visual Basic Editor.
 
Now go to your worksheet. (If you are in the same worksheet (Example: Sheet1) where you want to display the msg window, go to some other worksheet (Sheet2) and come back to the worksheet (Sheet1).
 
You will get the custom msg window.
 
Hope it will be useful to you.

Thanks mani

for best Topic & Help

Dear Rushikesh,

Please tell us, what is difficult to understand?

HOW CAN WE REOVER DATA CURREPTED EXCEL FILE WHICH IS PASSWORD PROTECTED ?

KINDLY REPLY SOON

 I want to know how to write an macro.. please suggest any book's on macro's and excel functions

thanx   dear........

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details