MSDN > 論壇首頁 > Visual Basic for Applications (VBA) > Need a function that places a string to a cell
發問發問
 

問題Need a function that places a string to a cell

  • Thursday, 9 July, 2009 21:07motorway 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    I need a function that places a string parameter to a cell. But the string must have the following properties: the names of Excel cells' names must be interpreted as their names, not as simple text, so I can move this cell for autocomplete multiple cells, and also when some cells delete/add -> names of cells in this parameter must change too. For ex., F(A1+3; B2=5) places A1+3; B2=5 to this cell. Also it must autocomplete and change to for ex., B1+3; C2=5 when adding a column etc.
    How can it be implemented?
    Guru, help!

所有回覆