Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This should be real easy, but I having difficulty. I want a function that
places a value in another cell. An example use might be like: =IF(F2210,SetCellVal(F23,"BUY"),SetCellVal(F23,"S ELL")). Though, I tried a dozen or so variations it presently looks like: Function SetCellVal(targe_cell As Range, target_value As String) 'Set Cell to Value target_cell.Value = target_value End Function I guess its more than a one liner. In advance Thanks for any Help given. Craig. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use cell_ref in place of an item in get pivot data function | Excel Discussion (Misc queries) | |||
I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire cell. | Excel Discussion (Misc queries) | |||
How can I place more than 30 arguments in an average function? | New Users to Excel | |||
Look up function best place | Excel Worksheet Functions | |||
"IF" function, have the facility to place a colour in the cell | Excel Worksheet Functions |