align and resize controls

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I have a few command buttons on the spreadsheet to let user does somethign
different.


I wanted to align, resize and equal space between contros.
I can not find anything like MS Access align and size manual to use.

Any way to make this tasks easier using Ms Excel?


Your help is great appreciated,
 
Bring up the drawing toobar. If you click on the Draw button one of the
options is Align or Distribute....

I think that is what you want.
 
Yes, Thnaks millions,


Jim Thomlinson said:
Bring up the drawing toobar. If you click on the Draw button one of the
options is Align or Distribute....

I think that is what you want.
Click to expand...
 
I have no idea what you are asking??? Please restate the question...
 
The distribut space and align to align the controls.

I would like to have all my controls have same width and height.
In MS Access, I can shrink size to Shortest or grow to widest.

Does MS Excel have this function?

Thanks again,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delay when userform resizes?? 3
Macro to have equal size charts and picture in MS Word 11
align autoshape with centre / right of excel cell 2
How to bottom-align a control on a UserForm? 2
Resize/align blocks in Vertical Block List 5
Custom Angle and Alignment with VBA 1
Custom button behaviour (activation and deactivation) 4
Command Button Alignment Problem 2

Back
Top