userform and spreadsheet formulas
 

hello:
I have a =SUM(k1:k93) in cell K94 along with some other formulas referencing
other cells.
I created a userform and added a command button at top of spreadsheet
labeled "Get Weight Summary"
The command button has a macro assigned:
Sub command_button2_click()
userform1.show
end sub

On the userform I added a textbox and set my properties for the
controlsource of this textbox to read =sheet1!k94 and when I ran the userform
macro the textbox appeared with the same value in it as on sheet1!K94 cell.
The problem is it took out my formula on Sheet1!K94 and changed it to a value
or number.
How can I reference this cell on the userform without having it erase my
formulas on Sheet1?
I did a test and erased the textbox on the user form and renetered the
formula =SUM(K1:K93) in cell K94 and it retained the formula. It seems when I
reference this cell on the userform using the textbox it converts my formulas
to plain numbers.
Any suggestions?
He4Giv
--
He4Giv (Dick)

userform and spreadsheet formulas
 

Private Sub CommandButton2_Click()

UserForm1.Show
UserForm1.TextBox1.Value = Range("K94").Text

End Sub


Make sure you use the Text property of Range("K94"), not the value
property.

The reason that the original form removed the cell formula is because
the cell <== control binding is a 2-way relationship. When you change
the value or close the form, the cell gets updated with the control's
value, which in this case was a plain number.

Nick Hebb
http://www.breezetree.com