Inserting code in Worksheet.Change
 

Hi all.

I am creating a new worksheet with VBA code from Access 2003. I copy records
to a range on the sheet, do cell formatting, create list and validation, etc.

What I need to do is insert some code in the new sheet's Change event.

Is there an easy, or correct and proper way to do this?

Thanks.
Keith

Inserting code in Worksheet.Change
 

easy:


Because it is worksheet code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. on the left pull-down select Worksheet
4. on the right pull-down select the type
5. paste you material in

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window



--
Gary''s Student - gsnu200829


"okiearcher" wrote:

Hi all.

I am creating a new worksheet with VBA code from Access 2003. I copy records
to a range on the sheet, do cell formatting, create list and validation, etc.

What I need to do is insert some code in the new sheet's Change event.

Is there an easy, or correct and proper way to do this?

Thanks.
Keith