i'm trying to write a simple function, all i want is that when i write anything in a cell(on column 'A'), the current time (hh:mm:ss) will be displaied in the same line but in the 'E' column and that it WONT update itself each time a type someting..
i just can't make it work..
plz help me..
help with excel
steve_baker
Sorry, I can't think of a good non-programmable way to do this off the top of my head. Anything using now() is going to recalc everytime rather than just once which is what you need to do this. Perhaps you'll have some better luck if you post it to the microsoft.public.excel.worksheet.functions newsgroup.
Regards,
Steve
sam2005
I'll let you handle the details, but basically you could add an event handler to the worksheet (handle the change event) and see if the target.column==1. This should get you going:
private void Sheet1_Change(Microsoft.Office.Interop.Excel.Range Target)
{
if (Target.Column == 1)
{
if (Target.get_Offset(0, 4).Value2 == null)
{
Target.get_Offset(0, 4).Value2 == DateTime.Now.ToString();
}
}
}
Regards,
Steve
Saviobd
10x ALOT Steve
i just can't express how greatfull i'm..
hope to find help where you directed me to..
Regards,
Tomer.s (Israel)
DHarve
i thing i made a huge mistake, i think i missunderstood the category here. i tried to add what you gave me to the Excel, and then i realiesed(i thing that's how you spell it) that this is not the functions i tried to write... i dont know where i went wrong.. but maybe you can help me figer out..
the function i tried was:
=if(and(e1="",a1<>""),now(),"")help, i'm totally lost....