Help with a function in Excel

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

you could use the worksheet change event as your trigger

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Range("A1").Value = Range("A1").Value * 12
Application.EnableEvents = True
End Sub

untested

 

lol, but I'm with lee why use the same cell

 

greenbrucelee,

From a data standpoint, how about manually multiplying by 12 then inputting that data into the cell?

 

First of all I want to thank all of you that answered to me and really helped me.

ThomasMc I am going to test the code asap.

And now why I want to use the same cell??Because I have been told so by the person that wants that excel book...

He just want to look more "professional" lets say but if I see that I cannot do it I told him that I will do it with the easy way!!

 

thats how I would have done it.

 

asymvivastos,

If you're looking for "more professional" then why not use a separate sheet, like sheet 2, to do the manual calculations such as "multiply by 12" then on the sheet 1 is where you'd have like a summary sheet of totals, averages, etc.