Microsoft 开发人员网络 >
论坛主页
>
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
- 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!
全部回复
- motorway, can you explain what you want a little more differently. i think maybe we just don't quite follow what you want to do.
FREE DEVELOPER TOOLS, CODE & PROJECTS at www.srsoft.us Database Code Generator and Tutorial
