create a grid

[dgrosen]

Good morning everyone.
I've been trying to work on this project but Im getting nowhere. I need your invaluable help
I need to create a variable grid. I need excel to position x number of option buttons on the x axis and on the y axis. Therefore if I input 5 on cell A1 and 10 on B1, it will insert 5 of this round objects on the x axis and 6 on the y axis, creating a grid with 50 buttons. Can it be done? How can I do it?
something like this:








Thanks a lot
Daniel

 

[RalphA]

YES!, I have done it. Here is my method:

You want to insert the number of columns in A1, and the number of rows in B1. O.K.

1. Put this formula in, say, A2: =IF(AND($A$1>=A$22,$B$1>=$A22),"*","")
(Please substitute the * symol for yours.)
2. Copy A2 throught the range you want to use, say, A2:G10.
3. Put this formula in A21: =A1
4. Put a 1 in cell A22, then put =A22+1 in A23, then copy A23 down so
as to, at least, match the chosen row range, 2:10 in my example, by
copying down to, at least, A30 (9 rows, 22 to 30, matching rows 2 to
10).
5. Put this formula in B21: =B1.
6. Put the formula: =(A22+1) in B22, then copy B22 to at least G22, so
as to, at least, match the chosen column range, A:G in my example.
7. DONE :D

 

[RalphA]

Re: Create a grid

Well, it works for keyboard symbols, but, I don't know how to make it for a drawing or an icon!
Hopefully, someone will pick this up, using VBA, and make it do what you want it to do!

 

[dgrosen]

:P thank you so much Ralph
But what Im trying to do is to insert option buttons in a grid.

What I need to do is:
1- define a grid (X and Y axis). Lets say I have 3x2.
2- then locate "option buttons" according to that specified grid
3- the option button will allow me to check and uncheck and will be a visual aid for me to know wich spot has a sample on it

thanks
daniel
[/code]

 

[RalphA]

Daniel, from your original question, I was sure you were working in Excel. But, from your last posting, I'm beginning to think you are talking about VB or VBA. I am not your man for this! Sorry.

Regards,

Ralph