VBA form Formatting

[edwedw]

I am using excel to build a database (as my company does not have access on thier systems). Records are entered via a VBA form.

What I would like to know is:

Is there anyway of adding formula, formatting and conditional formatting automaticly to the cells the form is populating?

I'm assuing this is going to be through VBA code rather than settings in the properties of the relevant feild.

Many thanks in advance

[royUK]

You can add all of these using VBA, try recording a macro to get the basic code.