Size of Objects in VBA

Padawan · Apr 10th, 2002, 05:18 PM

Am trying to insert some option buttons and checkboxes in my forms. The forms were originally created with about a 14 font. Would be a tremendous amount of work to change the forms to 10 or 12 font.

Problem is, I need the actual check box and option buttons bigger. It's easy to make the text larger, but I need the box you check and the button you select to be larger.

The form fits on the screen with Excel at 50%, but it is too small to see if the buttons are checked or not. If I increase Excel to 75 - 100%, you can see the check boxes, but the form is too large for the screen.

Any help out there for me?

THANK YOU.

Al Chara · Apr 10th, 2002, 05:25 PM

As far as I know, you cannot change the size of a checkbox.

Apr 10th, 2002, 05:18 PM	#1
Padawan Board Regular Join Date: Apr 2002 Location: California Posts: 386	Am trying to insert some option buttons and checkboxes in my forms. The forms were originally created with about a 14 font. Would be a tremendous amount of work to change the forms to 10 or 12 font. Problem is, I need the actual check box and option buttons bigger. It's easy to make the text larger, but I need the box you check and the button you select to be larger. The form fits on the screen with Excel at 50%, but it is too small to see if the buttons are checked or not. If I increase Excel to 75 - 100%, you can see the check boxes, but the form is too large for the screen. Any help out there for me? THANK YOU. __________________ John Der Garabedian

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

Apr 10th, 2002, 05:25 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	As far as I know, you cannot change the size of a checkbox.