Display result in userform (vba) textbox

[ilovelagar]

Hi,

I'm trying to get a userform textbox to display the result of a formula from a cell.

For example, cell A1=2 and cell B1=3. Cell C3=A1+B1, which displays 5. I have a textbox in a userform that displays the contents of cell C3, however it displays the formula, and not the result.

How can I get the textbox to display the result?

Any ideas

- I Love Lagar -

(PS. I actually love Guinness, which is a Stout, but "I Love Lagar" flows much better than "I Love Stout" )

[Leith Ross]

Hello ilovelagar,

You must have recorded the macro. The default property for a Range object is the Value, which will be the result of a formula. The only way to get the formula into the TextBox is to use the Formula property.

Example of Returning a Cell Value to a TextBox

Please Login or Register  to view this content.

Example of Returning theCell Formula to a TextBox

Please Login or Register  to view this content.