Need a code for my userform. Please help!

[enshi26]

I have attached soft copy of my xls file and a userform which I created based upon the workflow.

Hope somebody in the forum can help me with this. I tried to adopt some codes from some threads and gives out nothing or in other words Im not doing it correctly..

details goes like this

frame 1 "search for technical submittal" - it can either used any of the 3 lines to search in particular columns. it purpose is to identify if it already exist in the record. (if search gives a result, details will come out in frame 3 "existing detail")

frame 2 " new technical submittal details" - if search result gives zero, need new row to enter details and add.

frame 3 " existing submittal" - if already existing, possibility will be or sometimes new revision will come cmdbutton "create new revision" and new row will be added below the previous submittal.

frame 4 "update existing submittal" last 4 lines of frame 3 will depend on frame 4. if submitted to consultant received date will be updated. if returned by consulltant received date will be updated. next is to updated status and if any remarks.

I hope details are clear, as this is what my work is all about. thanks again if someone would care to share for me the code for this one..

thanks..