Posted to microsoft.public.excel.programming

external usenet poster

Posts: 557

Select more than on CommandButton

Hi all, I am trying to select all ComandButtons from 1 to 9 and I
wrote this code (see below) to do this job but I am getting error.
Please can any friend can help that what am I doing wrong.

Private Sub Image1_Click()
Dim i As Integer
For i = 1 To 9
Me.CommandButton&(i).Select
Next
End Sub

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
Using a variable to select a CommandButton and setting the caption	PCLIVE	Excel Programming	4	October 21st 08 06:22 PM
Ref Commandbutton	WLMPilot	Excel Programming	0	February 20th 08 02:51 PM
commandbutton?	Bobbykm	Excel Programming	3	September 30th 07 01:13 AM
CommandButton	Alvin Hansen[_2_]	Excel Programming	3	August 16th 04 06:35 PM
CommandButton	chris[_12_]	Excel Programming	1	April 15th 04 01:01 AM

All times are GMT +1. The time now is 10:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us