Microsoft Developer Network > 포럼 홈 > 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

  • 2009년 7월 9일 목요일 오후 9: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!

모든 응답