ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   align and resize controls (https://www.excelbanter.com/excel-programming/405992-align-resize-controls.html)

Souris

align and resize controls
 
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,

Jim Thomlinson

align and resize controls
 
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.
--
HTH...

Jim Thomlinson


"Souris" wrote:

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,


Souris

align and resize controls
 
Yes, Thnaks millions,


"Jim Thomlinson" wrote:

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.
--
HTH...

Jim Thomlinson


"Souris" wrote:

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,


Souris

align and resize controls
 
any pleace to resize fucntion to the same size?
Thanks again,

"Jim Thomlinson" wrote:

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.
--
HTH...

Jim Thomlinson


"Souris" wrote:

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,


Jim Thomlinson

align and resize controls
 
I have no idea what you are asking??? Please restate the question...
--
HTH...

Jim Thomlinson


"Souris" wrote:

any pleace to resize fucntion to the same size?
Thanks again,

"Jim Thomlinson" wrote:

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.
--
HTH...

Jim Thomlinson


"Souris" wrote:

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,


Souris

align and resize controls
 
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,

"Jim Thomlinson" wrote:

I have no idea what you are asking??? Please restate the question...
--
HTH...

Jim Thomlinson


"Souris" wrote:

any pleace to resize fucntion to the same size?
Thanks again,

"Jim Thomlinson" wrote:

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.
--
HTH...

Jim Thomlinson


"Souris" wrote:

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,



All times are GMT +1. The time now is 06:16 AM.

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