Automate adding radio buttons ?

[staticbob]

Guys,

Would it be possible to automate adding radio buttons to each row on this sheet ? I have 400 rows !!! Column D needs a check box in for each item, columns F & H should be mutually exclusive radio buttons.

Any ideas ??????

Thanks
Bob

handover.xls
	A	B	C	D	E	F	G	H	I
1		Section A - COMPLETION CERTIFICATES		Required		Enclosed		To Follow
2
3
4
5		Certificate of Practical Completion
6
7		Certificate of Building Regulations Compliance
8
9
10		Section B - BUILDING INFORMATION
11
12
13
14		Drawing Register of all as built drawings
15
16		Copies of all as built drawings
17
18		Schedule of principle materials used in construction
19
Sheet1

 

[staticbob]

Thanks Andrew,

Sorry for not spotting that.

Bob

 

[Ken Puls]

Hi Andrew,

Thanks for that! I wasn't aware that there was a special method to create event procedures. I've also never used the WorksheetSubstitute method to assign variables, either.

Learned a couple of new things here!

Cheers,

 

[Andrew Poulsom]

Hi Andrew,

Thanks for that! I wasn't aware that there was a special method to create event procedures. I've also never used the WorksheetSubstitute method to assign variables, either.

Learned a couple of new things here!

Cheers,

Hi Ken,

You did most of the work, so credit where it's due.

You were in the right place for the VBE code:

http://www.cpearson.com/excel/vbe.htm

but you just hadn't read it all (or forgot).

I could have used VBA's Replace function instead of WorksheetFunction Substitute, but it's new to Excel 2000, so I tend to avoid it.

 

[Ken Puls]

You were in the right place for the VBE code:

http://www.cpearson.com/excel/vbe.htm

but you just hadn't read it all (or forgot).

Actually, I had it stored in a tools file on my PC for easy access, and don't actually even remember reading Chip's page I got it so long ago. Pays to refresh the memory every now and then!

Thanks again!