EXcel97 VBA Question 
Author Message
 EXcel97 VBA Question

I am trying to programatically create a checkbox control on a userform in
Excel97 VBA. The help files don't seem have any info on how to do this.

    dim cb as checkbox
    set cb as new checkbox

does not work. I need to be able to create a variable number of checkboxes
(depends upon per-row info in a spreadsheet). I was hoping to use an array
of checkbox controls, but the VBA controls apparently do not support control
arrays. Anyway, if I can get one checkbox created I can manage the rest.

Anyone out there know how to create a checkbox control on a userform from
Excep97 VBA???

Any help that anyone can provide would be greately appreciated!


Michael Edelman

Sun, 18 Nov 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Newbie question about VB5, VBA and EXCEL97

2. VBA problem using RDO on WinXP or 2000 with Excel97

3. Excel97 VBA to swap data

4. vba excel97/2000 - getsaveasfilename

5. VBA for Excel97 how to avoid commandbar personalization

6. Sorting arrays - Excel97 VBA

7. VBA EXCEL97: How to get the range from a chart into a range object

8. Sendmessage API and Excel97-VBA Getselcount always returns 0

9. Simple Excel97-2000 VBA macro fails in Excel 2002

10. Excel97 VBA printing

11. Excel97 VBA Problem

12. VBA for Excel97-Cells size depending of resolution?


Powered by phpBB® Forum Software