new to vba- basic question

[tigertim71]

Hi- I'm quite new to VBA and am going through a book trying to learn this...

The book sets a basic task;

Write a VBA statement that sets the value in the ActiveCell of the worksheet called This Sheet in the workbook called ThisBook to the value of 20

So I manually set up a workbook called ThisBook and a worksheet called ThisSheet.

This code did not work and a message comes up "Compile error: Sub or Function not defined". Could someone let me know why?? (also attached) - Thanks.

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

Please read the Forum Rules about thread titles and Code Tags before starting your next thread.

[VBA Noob]

Also code should go in a module (See link)
http://www.contextures.com/xlvba01.html#Regular

Always try to avoid selecting whenever possible

e.g

Please Login or Register  to view this content.

VBA Noob

[tigertim71]

OK-thanks. This works, but what if it is an not an absolute reference, but relative (ie the active cell?).

Also, once I have set up a new module, should I use it for all other code within this workbook or keep setting up new modules?

Also code should go in a module (See link)
http://www.contextures.com/xlvba01.html#Regular

Always try to avoid selecting whenever possible

e.g

Please Login or Register  to view this content.

VBA Noob

[VBA Noob]

This works, but what if it is an not an absolute reference, but relative (ie the active cell?).

If it's for the activecell you don't need to specify the workbook and sheet

Also, once I have set up a new module, should I use it for all other code within this workbook or keep setting up new modules?

Up to you. If you have large blocks of code you may want to put each one in a module and rename the module to keep track of where the code is

http://www.vbaexpress.com/training/l...m#_Toc80291116

VBA Noob