@Ibetyou : I looked at you website and it is not exactly what I am looking for.
I already have this VBA fonction to calculate black scholes option value. Anyone knows how to isolate the other variable?
Function BSMValue(S, X, r, q, tyr, sigma, i As Boolean)
'returns Black-Sholes option value...