Array argument in macro command

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Array argument in macro command

FAQ

Thread Tools

Display Modes

11-17-2012, 08:44 PM

macropod

Windows 7 64bit Array argument in macro command

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Hi Wries,

Assuming BoxA, BoxB & BoxC are the control names and not their captions, try:
If Me.Controls("Box" & Element).Value = True

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM
How to capture start and ending Ref. Nos. in an array	KIM SOLIS	Excel	5	09-07-2011 07:43 AM
Word doc bug when closing from userform command button click macro	Joe Patrick	Word	1	07-05-2011 08:53 PM
Command Line Argument	xJediDadx	Outlook	1	02-21-2011 03:47 PM
Array into ComboBox + Macro-Text into ActiveDocument	Vivi	Word VBA	1	01-27-2010 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 AM.