Results 1 to 6 of 6
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Beginner Excel VBA Course (All versions)

    I've been asked to come up with a non-version specific course outline for a Beginner Excel VBA course. I have some ideas, of course but I am interested in what others think are important topics for new users. So really, anyone can answer my question regardless of skill level.
    The course model.
    I've taught a course previously that used building a flat file db as its model and I found that basic concepts seemed to be missed in order that the students finish the project correctly. I thought I'd have the students' build a series of small tools useful to any excel user that each illustrate the use of some portion of VBA language/syntax. Then, at the end of the day even if they decide they don't want to go any further with VBA at least they have the useful tools.
    Any comments are welcome.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Beginner Excel VBA Course (All versions)

    The idea of creating small tools is appealing.

    I would start with a very simple one, e.g. toggling grid lines.
    - Record a macro.
    - Inspect the code generated by the macro recorder.
    - Use F1 to get information, show how you can copy and paste examples from the help file.
    - Use F2 to see where a property or object fits into the object model.
    - Simple manual editing of the code.

    Explaining the use of Personal.xls would be very useful, as well as customizing Excel by creating a toolbar button and keyboard shortcut for a macro.

    Depending on how much the students already know, you could use your tool projects to
    - Explore non-application specific VBA (functions, procedures, loops, ...)
    - Explore the Excel object model and its representation in VBA.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Beginner Excel VBA Course (All versions)

    In addition to Hans' suggestions:
    How to create and use a user-defined function

    Maybe towards the end "adv beginner" events and how to have code triggered by events

    Steve

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Beginner Excel VBA Course (All versions)

    I'm almost embarrassed to post it, but I was developing an absolute beginner Excel VBA intro presentation and then the project was abandoned. So you are welcome to plagiarize the attached Word outline that I had started and never filled in. (And you can also chuckle at my ignorance of Word, two laughs in one.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Beginner Excel VBA Course (All versions)

    Thanks John. Now it is hurry up and wait to see if they'll pay me to develop the course. If they do, lots of virtual <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> (hey where did the Beer smilie go?) for you!

    Regards
    Catharine
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Beginner Excel VBA Course (All versions)

    The beer smilie is <!t>[cheers]<!/t>
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •