mahaveer
Member
i have one userform on which there are 5 textbox
textbox1 = serial number
textbox2 = invoice
textbox3 = suplier name
textbox4 = item name
textbox5 = amount
and i have one command button = save.
when i click on save then data from all textbox will save in sheet1 on coloumnA,B,C,D,E
now i have another userform on which the same 5 text box and one command button for edit
when i select serial no. then all the other textbox2,3,4,5 automatically gets their value
now user can change their value here easly but how to change the same value in excel....i mean i have no code for edit button?
can anybody tell me what should i do?
textbox1 = serial number
textbox2 = invoice
textbox3 = suplier name
textbox4 = item name
textbox5 = amount
and i have one command button = save.
when i click on save then data from all textbox will save in sheet1 on coloumnA,B,C,D,E
now i have another userform on which the same 5 text box and one command button for edit
when i select serial no. then all the other textbox2,3,4,5 automatically gets their value
now user can change their value here easly but how to change the same value in excel....i mean i have no code for edit button?
can anybody tell me what should i do?