#1   Report Post  
Iain
 
Posts: n/a
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Where is the bug in my array? Gail Gurman Excel Discussion (Misc queries) 1 January 25th 05 12:36 AM
Transpose into a _working_ transposed array Fred Holmes Excel Discussion (Misc queries) 1 January 13th 05 11:31 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
VBA Import of text file & Array parsing of that data Dennis Excel Discussion (Misc queries) 4 November 28th 04 10:20 PM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"