Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What the heck is wrong here?
Hey,
CALC.ActiveCell.Formula = CALC.ActiveCell.Value & "." This code above does not allow me to properly insert a "." (PERIOD) after the ActiveCell.Value. The code works fine when there is nothing in cell and when its not strictly a number. The following formats work correctly... ABC123.01 --123.01 "His tempature was 95.6" etc... But when the cell contains strickly numbers like 123 it doesn't want to insert it. Something to keep in mind is the fact that CALC is a userform with a spreadsheet plug-in feild (a spreadsheet within in a user form). All I want is for the ActiveCell.Value to stay put and have a "." (PERIOD) after the ActiveCell.Value. Any ideas? I been trying all sorts of things but Excel doesn't seem to want to cooperate. Any help is much appreciated!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What the heck is wrong here?
Gary,
Your code allowed me to insert the "." (PERIOD) but as soon as I tried to add another character into the cell it always kept the "." (PERIOD) at the end versus keeping it in its original placement location. Any ideas? I'm pulling my hair out on this one... Please keep in mind this is a spreadsheet inside of a VBA User Form so its a bit diffrent then it being a normal spreadsheet. Any help is much appreciated...I am woundering if maybe someone could help with a code to make the "." be instered as text instead of a trigger for 0.00 number format? Gary''s Student wrote: CALC.ActiveCell.Value = CALC.ActiveCell.Value & "." -- Gary's Student " wrote: Hey, CALC.ActiveCell.Formula = CALC.ActiveCell.Value & "." This code above does not allow me to properly insert a "." (PERIOD) after the ActiveCell.Value. The code works fine when there is nothing in cell and when its not strictly a number. The following formats work correctly... ABC123.01 --123.01 "His tempature was 95.6" etc... But when the cell contains strickly numbers like 123 it doesn't want to insert it. Something to keep in mind is the fact that CALC is a userform with a spreadsheet plug-in feild (a spreadsheet within in a user form). All I want is for the ActiveCell.Value to stay put and have a "." (PERIOD) after the ActiveCell.Value. Any ideas? I been trying all sorts of things but Excel doesn't seem to want to cooperate. Any help is much appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How the heck? | Excel Worksheet Functions | |||
Hide and unhide...what the heck!!?? | Excel Discussion (Misc queries) | |||
I am stupid and don't know what the heck I am doing wrong on this pivot table!!! | Excel Worksheet Functions | |||
I am stupid and don't know what the heck I am doing wrong on this pivot table!!! | Excel Programming | |||
I am stupid and don't know what the heck I am doing wrong on this pivot table | Excel Discussion (Misc queries) |