How to make drop down list (data validation) become longer by using any vba?

Hi everyone,

May i ask is that any way such as macros/VBA to make the drop down list by using data validation to become LONGER ?

Thanks and Regards!

I don't think so, but you could use this as a work around

HTML Code: 

I have viewed this link just now, its nice and i have try it out but it can't! for the part of the links cell inside the properties i not able to solve it because my data is saved on another sheet, and how do i can retrive my data from another sheet in the same workbook?