today i have very hard question
i doubt to find its answer
anyway i ask but please if u know let me know too
there is a workbook that located in local network lets call it "confirmation workbook"
there is another workbook in same location named "refrence",and it contains id's and related datas to id's
now i want to creat a userform1 in "confirmation workbook",that contain a textbox that i want to user enter an id number,and i want vb goes and searches that id datas in "reffrence workbook",and show related datas in userform1
i want to enter a data for example"confirmed" in text box in userform1 below the information of that searched id,and that "confirmed" sentence enter and save in related id in "reffrence workbook"
what a hard question!
do u know how can i do it?
every help will be appreciated and thanks in advance