Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula = "=5"
Hi,
ActiveCell.Value = "5" will give the cell text content equal to "5". ActiveCell.Formula = "=5" gives a *formula*. Although assigning "=5" to the Value property may achieve the same result, for the sake of readable code you should assign the Formula property rather than the Value (since a cell's value is either text content or *the evaluation* of the formula). Happy coding! Dag -- DagOystein.Johansen AT sage.fr -----Original Message----- I am using a Form to obtain a users input and then taking those values and inserting them into a spreadsheet. The problem is that the spreadsheet does not treat the values as numbers. I am using activecell.value to insert the values from the form onto the spreadsheet and have tried using activecell.numberformat as well as using the onchange event for the textbox to format the value all to no avail. If anyone has an answer I would be most grateful. Many thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions |