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)