By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

Visual Basic Info

P: 2
Hello, could someone please point me in the right direction? I often use Microsoft Access and to a lesser degree, Microsoft Excel. I need to learn more about writing code and am unsure as to whether I can do a course that would be applicable to both Access & Excel (would this be a Visual Basics for Applications course?) or just a Visual Basics for Access course?

Thanks for your help
Feb 1 '08 #1
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
What are you doing with access and excel ? Writing any macros ?
Feb 1 '08 #2

daniel aristidou
100+
P: 491
I think your looking for a VBA course......
VBA Should work for both access and Excel..
My advice is to ask the teachers...
Feb 1 '08 #3

P: 2
Thanks for the replies.

I have been using macros in Access ut hav reached a point were i need to use and read other peoples code.
Work has offered to put me on courses and this is were im a little confused about VBA/VB.

So from the above post I assume VBA will apply to Access and Excell.

So if im going to put in the time learning code am I better of looking at specific course on Access or learn something that I may be able to apply to other programs/situations i.e. VBA ?

Does that make sense?
Feb 2 '08 #4

Expert 5K+
P: 8,434
I don't know about the courses. But one way to pick up VBA in Excel is to record macros. Then you can edit them, and the code is there, already written for you. It's a fairly quick and easy way to learn how to perform specific tasks in VBA, and how the code fits together.
Feb 4 '08 #5

P: 58
My suggestion is to pick up a VB 6.0 book, or enroll in a VB 6.0 course (if they're still around). Then, migrate to VBA. Like Killer mentioned, Excel's Macro Recorder is a fast way to learn VBA, even faster if you know VB 6.0.
Feb 7 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.