About using a Sub

[robx2309]

Hi everyone,
I have a little problem but pretty annoying : I have a Sub in a module, and I'd like to use it as a formula in a cell, is that possible ?
And I'd also like to pass a parameter to that sub. The parameter would be a cell's range (like A6, or whatever). how can I proceed to do that ?

Thanks in advance for your answers, have a nice day !

[nimrod]

UDF(UserDefinedFunction)

[robx2309]

Basically what I want to do is have a drop down menu for the data validation in a cell (datas in that drop down menu are retrieved by a query, that's why I have to code it). But i cannot do that with a function (a function cannot create drop down menu in a cell). So I'm compelled to do that using a sub.
Do you have any idea about how should I do with a sub ?