ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Apply Button Enabled (https://www.excelbanter.com/excel-programming/368435-apply-button-enabled.html)

ssjody[_7_]

Apply Button Enabled
 

Is there a piece of code that that handles the condition of

If anything on my form changes then
Me.CommandbuttonApply.enabled = True

Thanks Jod

--
ssjod
-----------------------------------------------------------------------
ssjody's Profile: http://www.excelforum.com/member.php...fo&userid=3339
View this thread: http://www.excelforum.com/showthread.php?threadid=56526


Die_Another_Day

Apply Button Enabled
 
J-WALK has a good page on using Class Modules to trap events.
http://www.j-walk.com/ss/excel/tips/tip44.htm

I think if you don't check the "TypeName" then you can add controls of
different types. I haven't personally tried it that way.

HTH

Die_Another_Day
ssjody wrote:
Is there a piece of code that that handles the condition of

If anything on my form changes then
Me.CommandbuttonApply.enabled = True

Thanks Jody


--
ssjody
------------------------------------------------------------------------
ssjody's Profile: http://www.excelforum.com/member.php...o&userid=33398
View this thread: http://www.excelforum.com/showthread...hreadid=565267




All times are GMT +1. The time now is 01:30 PM.

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