How can we utilise the Excel with Visual Basic Library (VBE)?Please leave eamil. My id [e-mail]

Question

Excel:
=====
I have the Excel attached VB coding from a worksheet. Can anybody help on its usage of all topics such as watch window, immediate window,Froms, Modules, Macros,Class module, code building,List properties,List contents,Private function, Public function, add watch, Digital signatures, References, etc. Please email me at [e-mail]. I want to utilise it with the Excel and I want to create a database with Excel using VBE. Same like access.

Access:
======

I want to learn access thru a mini project using queries, macros and other designings.

Thannks for your warm attention and guide. May god bless you dear.

syedibrahim.A
Dubai.
U.A.E

Answer 1

My best advice is to order John Walkenbach's book:

Excel 2003 Power Programming with VBA

The ISBN number is: 0-7645-4072-6

I've been reading through this book. It could help you much more than someone could ever help you out through email.

To get to VBE, just press Alt + F11.

Once in VBE, to open the Immediate Window press Ctrl + G.

One thing you'll want to learn about is the Object Browser window. There is an icon to open that right below the Menu Bar.

My best advice though is to get the book I mentioned. It does a great job of taking you step by step through learning VB for Microsoft Excel. The author does a good job of showing the basic fundamentals a person needs to learn before he starts throwing a bunch of code at you.

I've been programming in Excel's VBE for about 5 years and the book has helped me learn a lot in the last few months.

Answer 2

Hi,I'm recently use MS VB to auto compile my working data,it's save a lot of time instead of manually hands on!Below are the few menu has been used for me:
Form-Double click the "form",then the toolbar will appear on screen,u can try it by your own,it only a simple task!
Marco-U need to record the job task during the first time u done.go to Tool>Marco>Record marco,save the marco anywhre u want,then start to demonstrate ur job,all the working are recorded by excel!After finish go to Tool>Marco>Stop record.Open the excel which is save the Marco,press Alt+F11,all the job done can refer on it,it appear by word,u can lern & try it by ur self.
The best way is download the tutorial from internet.
For further info kindly email to [e-mail]
Hope keep in contact.

ECOL
Penang,
Southeast Asia.