vijayamani1987
New Member
- Joined
- Mar 16, 2014
- Messages
- 32
Hi people,
I am using a user defined function formula in my excel sheet. The formula is
PlaceBO = (Exch, TrdSym, Trans, Qty, LmtPrice, SqOffValue, StoplossValue, TrailPoints, OrdType, TrgPrice, cTag)
I am using this for trading. The problem is I am manually editing the formula every time. I tried CONCATENATE formula which gives value as follows,
PlaceBO("NSE","sail","BUY",100,600,2,2,0)
Problem is again I needed to double click that cell and enter symbol "=" at the beginning of the formula. How can I make it through VBA. Please through some light. Thank you
I am using a user defined function formula in my excel sheet. The formula is
PlaceBO = (Exch, TrdSym, Trans, Qty, LmtPrice, SqOffValue, StoplossValue, TrailPoints, OrdType, TrgPrice, cTag)
I am using this for trading. The problem is I am manually editing the formula every time. I tried CONCATENATE formula which gives value as follows,
PlaceBO("NSE","sail","BUY",100,600,2,2,0)
Problem is again I needed to double click that cell and enter symbol "=" at the beginning of the formula. How can I make it through VBA. Please through some light. Thank you