set cell value with vba and get the formula in the Excel function bar

[MarieBocc]

Hello everyone,

I am trying to set the value of a cell by using vba. The thing is, this cell is in a column where all cells are set by the following formula :

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(OR((H17<>"");(F17<>"");(E17<>""));SEARCH("zzz";B$9:$B17);"")

So when the user clicks on any cell, this is what the Excel function bar displays. But if I set my cell value with vba, how can I get my cell to display the same formula in the Excel function bar ?

To begin with, is it even possible ?

[/FONT]

Thank you for reading,

Marie​

 

[MarieBocc]

Hello again,

I thought about it from a different angle and here is what I came up with and it worked :

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Cells(myRow - 1, 1).AutoFill Destination:=Range(Cells(myRow - 1, 1), Cells(myRow, 1)), Type:=xlFillDefault

note : myRow is the row I want to spread the formula to. (The same formula as I have in the whole column -> so also in the previous cell.)
[/FONT]