can anyone tell me how this should be done. i have an excel UDF(user defined function) used as a formula on some cells, inside this function depending on the values it is passed i need to access database and get updated values. I m fairly new to excel vba but have good programming experience. I would like to know before attempting if its even possible inside a function when its being used as a formula. Previously i wasted my time getting a value from another workbook inside of a function only to find out it wasnt possible inside a function when its used in a formula.
any help in this matter will be appreciated.