Convert formulas to values in a test box

[sabraham]

I am copying the value in a cell to another sheet's cell. I want to convert the formulas on the second cheet to reflect their value. I do this all the time within cells by using Past Special and Values however it doesn't give me that option within the Text Box

Thanks

 

[Rick Rothstein]

Just assign the Value property of one cell to the Value property of the other cell. For example...

Worksheets("Sheet1").Range("A2").Value = Worksheets("Shee2").Range("B4").Value

 

[sabraham]

I'm sorry I didn't state the question clearley. I an copying the value in a cell from one sheet to a text box on a second sheet using =Sheet1!A2. I need to convert the formula in the Text Box to the Value of the formular