Replies

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

thanks to all.cheers

thanks to all.cheers

if it so compicated to explained steve..do you mind ..adjust my code and give me some sample file ..the way that

you explained to me at above..i haveno idea to fix this mess..thanks

thanks steve for the reply,

what i want to do is use the userform to fill data..

let say..in row 1.that is a3..i put number 1..and i will fill continously until the last row nad that is q3..

then i will move to the next row..and that is a4..iand i will repeat the same operation..

let say..in the 1st row..in cell b3..i accidentally put awrong speling..and i want to edit it..b4 this..using the same userform and the same coding..in the number box , i will just simply key in number 1..and walla..all the data that i have key in..will apperaed i the userform..so i just select which cell that i’ve make mistake..and edit it..

and hit the button..”accept the data” and the mistake will be corrected..

but in the sample file that i attach..this thing is not happen..

after i fill the number box..eg..number 1..after i hit enter or tab..all the data in the same row..from a3 to q3..will be deleted automatically..

thats very weird and i dont know how to fix it..thanks again

thanks steve..it works like charm..

thanks steve..it works like charm..

Edited by WyllyWylly to add URL tag. See the Quick Guide.[/i][/size]

Helo guys ,

This is my 1st time here..

Just want to ask..if there any free host that permit user to upload mp3 songs to their sites..

For free of course..thanks..

Like this one..but it is LIMITED

http://www.orderformcity.com/music/uploader.html%5B/url%5D

Edited by WyllyWylly to add URL tag. See the Quick Guide.[/i][/size]

Helo guys ,

This is my 1st time here..

Just want to ask..if there any free host that permit user to upload mp3 songs to their sites..

For free of course..thanks..

Like this one..but it is LIMITED

http://www.orderformcity.com/music/uploader.html%5B/url%5D

thanks guys for the feedback..regards

thanks guys for the feedback..regards

thanks steve..it works. regards

thanks steve..it works. regards

nope catherine..

i just want to protect all my sheets everytime i open my file. thanks

nope catherine..

i just want to protect all my sheets everytime i open my file. thanks