Thread: Dropdown list with Functions

Hi All,

I hope you can help me work out if this is possible.

2 Columns. First called Field, Second called Command

In the Field column is things like, firstname, surname, address etc

In the Command column is the corresponding vba function to query AD and pull this info back in the form of =getadinfo("cn",A2,"givenname")

Therefore Firstname = =getadinfo("cn",A2,"givenname")

Now what I want to do is to create a dropdown list based on the Field column and upon selecting Firstname/Surname/Address etc, then the function from the Command column is performed.

Is this even possible especially since the cell with the function "appears" blank?

Thanks very much.

Does anyone have any ideas?
Thanks,