Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 5th 07, 05:41 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 162
Default 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   Report Post  
Old January 5th 07, 07:20 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 162
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How the heck? Dave Excel Worksheet Functions 6 April 8th 08 03:34 AM
Hide and unhide...what the heck!!?? LeahT Excel Discussion (Misc queries) 6 March 21st 08 03:10 AM
I am stupid and don't know what the heck I am doing wrong on this pivot table!!! Chris Excel Worksheet Functions 10 September 10th 06 02:18 AM
I am stupid and don't know what the heck I am doing wrong on this pivot table!!! [email protected] Excel Programming 5 September 9th 06 11:55 PM
I am stupid and don't know what the heck I am doing wrong on this pivot table [email protected] Excel Discussion (Misc queries) 1 September 9th 06 10:24 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017