ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enabled problem on commandbutton (https://www.excelbanter.com/excel-programming/298639-enabled-problem-commandbutton.html)

Swordster

Enabled problem on commandbutton
 
When i change the Enabled propety on a commandbutton in the VBA code, the commandbutton still looks and acts like its not bin changed. Any one knows why?

Swordster

Enabled problem on commandbutton
 
Code exampel
Public Sub UppdateButtons(
Dim bBool As Boolea
If combSheets.ListIndex 0 The
bBool = Tru
Els
bBool = Fals
End I
cmdDeleteSheet.Enabled = bBoo
cmdCalcData.Enabled = bBoo
End Su

This code does change the propety (if you "watch" it") but nothing hapends on the command button on the sheet...


All times are GMT +1. The time now is 05:17 PM.

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