Hi guys,

Just a newbie here in the forum. I stumbled upon this site in search for an answer from Excel (VBA) experts around the globe. Hope I get to find them here!

My problem is the ever recurring error 1004 ("Unable to get the VLookup property of the worksheetfunction class") whenever I trigger the ComboBox1 in Userform1, Activities tab (I used multipage here).

Here's the code:
HTML Code: 
Also attached is the "sanitized" sample workbook for reference (pardon me if you see my programming skill and structure a bit messy, still newbie here ).

In addition, why does this file keep on popping with message "This workbook contains links to one or more external sources that could be unsafe."? How can I get rid of it?
Hope you can help me with this. This functionality is very crucial in this workbook.
Thanks in advance guys!!!

sample workbook.xlsm