VBA to automatically update cell information

[Anarchus]

Hi there,

I need specific cells to update automatically, I currently have the following VBA:

Please Login or Register  to view this content.

This is great, except I still have to double click on the cell (O34 / O35 / O36) to get it to actually update.

The cells mentioned are actually linked to different commandbuttons (these are doing what I need them to do).

The above code is on a sheet that will mainly be 'hidden', its where I keep all the formula's for the workbook so I can lock the sheet and hide it so no one messes it up.

Is there something I can include in the code to ensure the values are automatically updated as it's done so I don't need to double click on the cell before it works?

Thanks

[gmr4evr1]

Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[Anarchus]

Thanks gmr4evr1, that's helped!

[gmr4evr1]

You're welcome, glad it worked out for you.