Replies

wowwwwwwwwwwwwww..

you are awesome steve..thanks a zillion..yet again your save me..

why i didnt think about the correct formula ..the one that you provide:

=IF(ISERROR(G4+L4+Q4+V4+AA4),0,G4+L4+Q4+V4+AA4)

instead of doing that i use.. this formula :

=IF(ISERROR(G4+L4+Q4+V4+AA4),”0″,G4+L4+Q4+V4+AA4)

my problem solved..god bless you steve..cheers

wowwwwwwwwwwwwww..

you are awesome steve..thanks a zillion..yet again your save me..

why i didnt think about the correct formula ..the one that you provide:

=IF(ISERROR(G4+L4+Q4+V4+AA4),0,G4+L4+Q4+V4+AA4)

instead of doing that i use.. this formula :

=IF(ISERROR(G4+L4+Q4+V4+AA4),”0″,G4+L4+Q4+V4+AA4)

my problem solved..god bless you steve..cheers

thanks hans for the explanation.regards..

thanks hans for the explanation.regards..

hellp hans,

so far your code works perfectly..

just 1 simple question..but its so hard for me that dont so familiar with words..

let saya i want to use button..like command button..

in other word, i want to use your code..and attach it to a button..

so when ever i push the button..your code will run..

i try to use the command button..but unfortunately , it fail..

havy any idea..thanks

hellp hans,

so far your code works perfectly..

just 1 simple question..but its so hard for me that dont so familiar with words..

let saya i want to use button..like command button..

in other word, i want to use your code..and attach it to a button..

so when ever i push the button..your code will run..

i try to use the command button..but unfortunately , it fail..

havy any idea..thanks

thanks Eowyn..for the link and the info..
will try it both..hehe

thanks Eowyn..for the link and the info..
will try it both..hehe

appreciate it very much hans

i will try the code and will tell you the result..regards

appreciate it very much hans

i will try the code and will tell you the result..regards

thanks hans ,

i dont want to opened the files because ..its too many..the example i give in this post is not the exact total of my files..

let say if i have 100 files..so it takes a long time for me to edit it..then closed it..open another one..then close it..and so on..

so i need so automate it to make my work more efficient..thats why i need that macro..

could you please help me hans..thanks

thanks hans ,

i dont want to opened the files because ..its too many..the example i give in this post is not the exact total of my files..

let say if i have 100 files..so it takes a long time for me to edit it..then closed it..open another one..then close it..and so on..

so i need so automate it to make my work more efficient..thats why i need that macro..

could you please help me hans..thanks

Thanks steve for the prompt reply..
but i think that ..you ..dont understand what i’m trying to do..

for more information , please refer to my new file that i attached

you see in this file, every time i want to edit the data , i just put the number in the item box..let say #5 and hit enter..

after the that i can edit it easily..after i hit the accept data button..the correction that i’ve submit will be appear and yet..the data that i dont want to edit ..remains

this is really totally different with the one that i post earlier..even though i use the the same coding , i dont get the same result..

what am i doing wrong..please refer to my new attachment..thanks

Thanks steve for the prompt reply..
but i think that ..you ..dont understand what i’m trying to do..

for more information , please refer to my new file that i attached

you see in this file, every time i want to edit the data , i just put the number in the item box..let say #5 and hit enter..

after the that i can edit it easily..after i hit the accept data button..the correction that i’ve submit will be appear and yet..the data that i dont want to edit ..remains

this is really totally different with the one that i post earlier..even though i use the the same coding , i dont get the same result..

what am i doing wrong..please refer to my new attachment..thanks

Hello again guys.

I’ve created a useform..
It works fine..

but the problem occured when i want to edit the data..
it seems that after i enter the number of the pupils in column a ,
it will automatically delete all the data in the same row..

what i want to do is edit certain data in the particular rows ,
but after i fill the number in the item box in column a , let say 1,
after i hit enter and go to the name column..that is in column b , all the data in teh same row will be deleted automatically..

how can i overcome this problem..thanks a bunch

plz refer to attachment