Add Formula To Text Box In Excel
November 21st, 2011
Comments off
I would like an excel file to use the formula in a text box instead of the text.
This is the formula i want show the result of in the text box
TextBox1.Text = Application.CountIf(Range(“a1:a10″), “B”))
basic example
How can I make the result show in the text box? I have tried adding the formula to value field, but it just shows up the formula not the result?
