Control button arrays

bolo · Mar 24th, 2002, 06:39 PM

Hi wonder if anyone can help. Probably quite simple but i am new to this. Have 9 command buttons labelled CmdBut11 to CmdBut33. Is there a simple way i can assign these 9 buttons to a 3X3 array. Thanks

Anne Troy · Mar 24th, 2002, 07:24 PM

Do you mean group them in threes so that only one can be chosen? Generally, then, I think option buttons are used instead. Anyway, I think you need to draw a grouping box around them.

bolo · Mar 24th, 2002, 07:43 PM

Quote:

On 2002-03-24 18:24, Dreamboat wrote:
Do you mean group them in threes so that only one can be chosen? Generally, then, I think option buttons are used instead. Anyway, I think you need to draw a grouping box around them.

All i want to do is put CmdBut11 into 1,1 of the array, CmdBut12 into 1,2 and so on. Have tried to use for a string of the form "CmdBut" &i&j. Is there a way to assign the command button of the same name as this string formed into the array? Thanks.

Mar 24th, 2002, 07:24 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Do you mean group them in threes so that only one can be chosen? Generally, then, I think option buttons are used instead. Anyway, I think you need to draw a grouping box around them. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 06:39 PM	#1
bolo Board Regular Join Date: Mar 2002 Posts: 389	Hi wonder if anyone can help. Probably quite simple but i am new to this. Have 9 command buttons labelled CmdBut11 to CmdBut33. Is there a simple way i can assign these 9 buttons to a 3X3 array. Thanks