Want to be an expert in Excel-Macro

Page no : 2

Pravee Haridas (Lecturer - CPT) (112 Points)
Replied 04 August 2008

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

Upgrade to CAclubindia Pro. Subscribe Now!

Rushikesh (Chartered Accountant - Manager Finance) (2375 Points)
Replied 07 August 2008

Difficult to understand :-(

CA.Madhavan (Chartered Accountant) (942 Points)
Replied 07 August 2008

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

Ravi Shah (Internal Audit Professional) (92 Points)
Replied 08 October 2008

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

Deepak (Free Lancer) (48 Points)
Replied 10 October 2008

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

Upgrade to CAclubindia Pro. Subscribe Now!

Kamaraj Mani. N (Chartered Accountant - Product Manager) (553 Points)
Replied 23 January 2009

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.

Copy the Code given above.
Go to Tools>Macro>Visual Basic Editor or press Alt+F11
Select a worksheet (Where you want to display the msg window) from the Project-VBA Project Windows.
Paste the code.
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.