ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Naming an Array (https://www.excelbanter.com/excel-discussion-misc-queries/19948-naming-array.html)

Iain

Naming an Array
 
Hi,

I have built an interactive menu system in Excel that is based around moving
a series of Text boxes and objects in front/behind an opaque square using
simple macros.

One problem with this method is that when I need to update the menu by
either adding or removing an item, I have to manually change the array
selection in the macro, so that the list of objects to move includes (or
doesn't as the case may be) the new or removed object.

Is there a way to apply a name to an array that I want to select so I can
simply change the definition of the group to update the objects that are
moved, much like what can be done with the "Insert|Name|Define" approach for
cells?

Thanks for your help!


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com