ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "aligning option buttons" (https://www.excelbanter.com/excel-worksheet-functions/160940-aligning-option-buttons.html)

scottshaw

"aligning option buttons"
 
I can align and distribute text boxes on my form with the options in the
drawing menu. I cannot align or distribute option buttons or check boxes the
same way as I can only select one at a time. Ctrl-select or shift-select
does not do it. Any help greatly appreciated!

Scott

Dave Peterson

"aligning option buttons"
 
I could click on the first checkbox and ctrl-click on the subsequent checkbox
and all would be selected.

I tested with checkboxes from both the forms toolbar and from the control
toolbox toolbar.

scottshaw wrote:

I can align and distribute text boxes on my form with the options in the
drawing menu. I cannot align or distribute option buttons or check boxes the
same way as I can only select one at a time. Ctrl-select or shift-select
does not do it. Any help greatly appreciated!

Scott


--

Dave Peterson

scottshaw

"aligning option buttons"
 
Thank you for your response Dave. I am on excel 2003. Is that your version?
I tried every way I know to select more than one option button.

"scottshaw" wrote:

I can align and distribute text boxes on my form with the options in the
drawing menu. I cannot align or distribute option buttons or check boxes the
same way as I can only select one at a time. Ctrl-select or shift-select
does not do it. Any help greatly appreciated!

Scott


Dave Peterson

"aligning option buttons"
 
Yes. I'm using xl2003.

If you start a new workbook, can you do it there?

scottshaw wrote:

Thank you for your response Dave. I am on excel 2003. Is that your version?
I tried every way I know to select more than one option button.

"scottshaw" wrote:

I can align and distribute text boxes on my form with the options in the
drawing menu. I cannot align or distribute option buttons or check boxes the
same way as I can only select one at a time. Ctrl-select or shift-select
does not do it. Any help greatly appreciated!

Scott


--

Dave Peterson


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com