Need help to lookup through each cells in a range based on two condition

[petroes]

what am i trying to do here is simply just like the gantt chart i want to write into a cell in range that meet two conditions, but got an error runtime 13: type mismatch, i still can figure it out what is wrong with the code, and can you show me how to loop through each row from column name in worksheet "dtbs"...
here is the workbook that i've been working on....

Please Login or Register  to view this content.

[torachan]

Place as your very first line in the UserForm module 'Option Explicit'
Then run debug, as each fault shows, declare any variables (Dim) immediately under the line 'Option Explicit'
You will also find a number of typo's, once you have done this resubmit your code, we will try to help then.
Help us to help you, run debug, proof reading is tedious & time wasting for me.