How do I enter a spreadsheet formula into a userform?

[yeekiat]

Hi,

I would like to create a userform whereby the user can enter a
spreadsheet formula into a userform. The userform should also have a
done button so that when the done button is clicked, the formula is
stored in another cell in this worksheet.

Which control do I use to achieve this? The RefEdit doesn't work and
the Textbox doesn't seem right either.

Regards,
Yee Kiat

 

[yeekiat]

In the event that people might be confused with what I'm trying to do,
let me re-explain the problem.

Lets say I want to have a formula in cell C4 that contains the formula
=SUM(C1:C3)

I want to be able to create a userform that allows the user to enter
the formula =SUM(C1:C3) in a textbox or something that else that does
the job. When a 'Done' button is pressed on the userform, the formula
is placed in the cell C4.

Hope someone can help me out on this.

YeeKiat

 

[Gary''s Student]

Here is the general idea:

Sub yeekiat()
Dim s As Variant
s = Application.InputBox(Prompt:="Enter Equation:", Type:=0)
Range("C4").Formula = s
End Sub