MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Free Tutorials?

  Asked By: Hamish    Date: Feb 20    Category: MS Office    Views: 1810

I have tried to create a simple Excel form and database to help keep
track of my pizza delivery work. I started with a simple
spreadsheet form and then developed a script that would save the
data in an Excel database. However, it is a bit cumbersome to use,
I'd like to have it calculate running totals and I would like to
learn more about VBA.

Can anyone recommend a good on-line (FREE) tutorial that I could
use? I'm not against paying for training but I find that there is
quite a bit for free so I'm starting here first.

If anyone is really interested, I'd welcome some direct conversation
on my "project" *smile*.



4 Answers Found

Answer #1    Answered By: Penny Clark     Answered On: Feb 20

I am in the learning process. I borrowed some books from the library and made
some notes.

Another good  way to learn is by using the macro recorder.

Answer #2    Answered By: Mohammed Evans     Answered On: Feb 20

I went to the library today and the few
VBA books they had were checked out. I am on the waiting list.

I was working on my project  today and have what might be a simple
question. How do you write new data into a spreadsheet cell? I have
a cell for Year to Date Earnings and what I want to do is to keep it
current. I think that I have gotten the cell data into variables.
Now I need to add the two variables together and put the result in the
spreadsheet. Can you assist.

At the risk of really showing how much of a hack I am :-0, I am
putting my code below.

' Select the cell in the spreadsheet that has today's data
Range("f6").Select 'the cell is F6
' Assign a variable to the current day total
total = ("f6")
' Select the spreadsheet cell that has the current year total
' Assign a variable to the current year total
mtd = ("f7")
' Write the NEW year to date total in cell F7
"f6" = mtd+total '<----This is the statement that doesn't work

Answer #3    Answered By: Abelard Fischer     Answered On: Feb 20

I just noticed this thread asking for free  tutorials.

Know that TechTrax is loaded with free tutorials  of all types and Mark
Thorpe create  a great series of excel  VBA newbie articles. You can find  them
at his article link here:


Answer #4    Answered By: Birke Fischer     Answered On: Feb 20

I took a quick look and I think that I may find  my
answer in one of Mark Thorpe's articles.

Didn't find what you were looking for? Find more on Free Tutorials? Or get search suggestion and latest updates.