Posted to microsoft.public.excel.programming

Jason[_31_] Jason[_31_] is offline

external usenet poster

Posts: 2

renaming array of controls

from the default CommandButton1,2,3........100.

to

MyCmb1,2,3.....100

I tried

Dim x As Single
For x = 1 To 100
Controls("CommandButton" & x).Name = "MyCmb" & x
Next x

error "Can't set at runtime"

how else can I quickly change these?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
ActiveX Controls vs Form Controls	Alex	Excel Discussion (Misc queries)	1	January 11th 06 08:46 AM
excel VBA set array controls	Jason[_31_]	Excel Programming	1	June 30th 04 11:38 PM
Renaming	ianripping[_66_]	Excel Programming	3	May 22nd 04 12:02 PM
Renaming within VBA	Brent McIntyre	Excel Programming	4	August 21st 03 02:10 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us