Results 1 to 4 of 4

Toggle Button set to true if cell is equal to text

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2010
    Location
    CO
    MS-Off Ver
    Excel 2003
    Posts
    18

    Toggle Button set to true if cell is equal to text

    Hello

    I'm trying to toggle a toggle button on a worksheet if a cell value data is equal to "Premium". I tried this code below but it didn't work. Is this close or is it not possible?
    Thanks in advanced.

    'this toggles the CoS button if "Premium" is selected
    Private Sub Worksheet_Change(ByVal Target As Range)
        If Target.Address = "D9" And Target.Value = "Premium" Then
            TglButCoS.Value = True
            Call TglButCoS_Click
            TglButCoS.Value = True
        End If
    End Sub
    Last edited by Leith Ross; 07-29-2010 at 01:28 PM. Reason: Added Code Tags

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