Results 1 to 17 of 17

enabling a vba control form button in vba code

Threaded View

  1. #10
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: enabling a vba control form button in vba code

    With ThisWorkbook.Sheets("CommissionTest")
    
        If .Range("A18").Value = "" Then
        
            .Buttons("CommissionMacro").Enabled = True
            
            .Buttons("CommissionUpdate").Enabled = False
            
        Else
        
            .Buttons("CommissionMacro").Enabled = False
            
            .Buttons("CommissionUpdate").Enabled = True
               
            MsgBox "The Agencies tab needs to be updated." & vbNewLine & vbNewLine & "Please select the Update Agencies tab button"
            
        End If
    
    End With
    is the equivalent of what I posted.
    Last edited by OnErrorGoto0; 02-27-2012 at 08:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1