Creating User Entry Forms

[wrbnoh]

I would like to create a custom user entry form similar to the standard form under "Data" in Excel(r).
Actually, I have done this. But, my problem is that when I use the VBA form, for data entry, my formulas for the calulated fields don't automaticly fill.

(Example: I have five columns that contain variables that need entered - the next 10 columns are calculated fields, based on the variables)

 

[Zathras]

Easiest way is to set the .FormulaR1C1 property of each of the cells into which you need to poke a formula. (or depending on your circumstances you could use the .Formula property)

Check the help file, play around a bit and you should get the idea. (Start by displaying the .Formula or .FormulaR1C1 property of a cell that has a formula using MsgBox.)