Combo box and lables

[Ian Morrin]

Hi,

I am trying to create an email questionnaire using Excel, I have added Combo
boxes and label's. Is there a way to line up the combo boxes and lables
without just using the eyeball method?? Some sort of shift click thing as
there is in other Microsoft software??

Thanks

Ian

 

[Jim Gordon MVP]

Hi,

Yes, Excel has the ability to line up combo boxes and other objects on
worksheets and on userforms.

On worksheets, turn on the drawing toolbar (View > toolbars > drawing).
There is a tear-off menu on the Draw > Align or Distribute button. Use
that menu with the Select Objects button, also located on the drawing
toolbar.

Are you familiar with Dialog worksheets? Control-click on a sheet tab,
then choose Insert from the pop-up menu, the Microsoft Excel 5.0 dialog.
You can use the same Align or Distribute toolbar and drawing tools on
Dialog sheets.

If you are making userforms in the visual basic editor the alignment
tools are on the Format menu of the editor.

Excel is a very powerful tool.

-Jim

 

[Ian Morrin]

Thanks Jim much easier!!!!

Ian