ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   format painter (https://www.excelbanter.com/excel-programming/290979-format-painter.html)

gregork

format painter
 
Hi,
Is there a tool for format painting when adding controls from the control
toolbox. For example: Once I have set the properties for a command button I
want to apply the same properties to all buttons I add without having to go
back into properties and individually changing them all again.

regards
gregork



Bob Phillips[_6_]

format painter
 


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gregork" wrote in message
...
Hi,
Is there a tool for format painting when adding controls from the control
toolbox. For example: Once I have set the properties for a command button

I
want to apply the same properties to all buttons I add without having to

go
back into properties and individually changing them all again.

regards
gregork





Bob Phillips[_6_]

format painter
 
Gregor,

Don't think so, but it would be nice wouldn't it? There's a challenge.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gregork" wrote in message
...
Hi,
Is there a tool for format painting when adding controls from the control
toolbox. For example: Once I have set the properties for a command button

I
want to apply the same properties to all buttons I add without having to

go
back into properties and individually changing them all again.

regards
gregork






All times are GMT +1. The time now is 01:09 AM.

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