Need a Macro to enter formula

[vijayamani1987]

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

 

[Logit]

.
Presuming for this example, you want the formula to go in Sheet #1 / Cell B8:

Option Explicit


Sub entForm()
Sheets("Sheet1").Range("B8").Value = "=PlaceBO(""NSE"",""sail"",""BUY"",100,600,2,2,0)"
End Sub

Note there is a quotation marks at the beginning and end of the formula. Also, if there are quotation marks required within the formula itself, there must be an additional
quotation mark next to it. When the formula is pasted into the cell, the extra quotation marks are not transferred to the cell.

Also, there is no way for me to know if your formula actually works. The example is based off what you have posted.

 

[vijayamani1987]

Hi Logit,

Thank you. It's working and placing orders. But I need it work in other way. Perhaps I didn't explained my problem clearly. Below is the actual sheet.
[TABLE="width: 1371"]
<colgroup><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 1371"]
<colgroup><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD]Exch[/TD]
[TD]TrdSym[/TD]
[TD]OrdType[/TD]
[TD]Qty[/TD]
[TD]LmtPrice[/TD]
[TD]SL
[/TD]
[TD]TSL[/TD]
[TD]order format[/TD]
[TD]Place Order[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2[/TD]
[TD]NSE[/TD]
[TD]DABUR[/TD]
[TD]BUY[/TD]
[TD]60[/TD]
[TD]410[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]=PlaceBO("NSE","DABUR","BUY",60,410,3,1)[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3[/TD]
[TD]NSE[/TD]
[TD]ASHOKLEY[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4[/TD]
[TD]NSE[/TD]
[TD]HCLTECH[/TD]
[TD]SELL[/TD]
[TD]25[/TD]
[TD]915[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]=PlaceBO("NSE","HCLTECH","SELL",25,915,6,1)[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]5[/TD]
[TD]NSE[/TD]
[TD]ITC[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]6[/TD]
[TD]NSE[/TD]
[TD]NTPC[/TD]
[TD]SELL[/TD]
[TD]200[/TD]
[TD]65[/TD]
[TD]0.8[/TD]
[TD]0[/TD]
[TD]=PlaceBO("NSE","NTPC","SELL",200,65,0.8,0)[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7[/TD]
[TD]NSE[/TD]
[TD]TATAGLOBAL[/TD]
[TD]BUY[/TD]
[TD]80[/TD]
[TD]201[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]=PlaceBO("NSE","TATAGLOBAL","BUY",80,201,1,0)[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]8[/TD]
[TD]NSE[/TD]
[TD]WIPRO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]In your code the formula contains exact values. But the values in columns D:H keep changing. And so the values in column I. What I am currently doing is whenever a order formula appears at column "I", I will copy it manually and paste it in adjacent cell at column J. Then in that cell (in column J) I have to double click and press enter. Then only the order will pass.

Your code is passing the order. But I need it to search it in column I for orders and place it in column J.

Thanks in advance.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]