Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform for spreadsheet | Excel Discussion (Misc queries) | |||
Userform to spreadsheet | Excel Programming | |||
userform data to spreadsheet | Excel Programming | |||
spreadsheet on userform | Excel Programming | |||
Spreadsheet in an Userform | Excel Programming |