How to pass values from an array to a drop down list in a certain cell (not combo list) in excel VBA
<p>I'm trying to pass values from an array to a drop down list in a specifc cell.
Say I have an array which contains the values 1,2,3 and I want cell A1 to contain a drop down list with these value, Is there any way I can do this? 
I'm trying to achive this without having to first assign these value to different cells and use data validation. (And as stated in the title, I don't want to use combo boxes or user forms)</p>