Results 1 to 2 of 2

Making a Checkbox appear and disappear using a drop box selection

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Johannesburg
    MS-Off Ver
    Excel 2007
    Posts
    7

    Making a Checkbox appear and disappear using a drop box selection

    FYI: I'm running Office 2007< however people with both 2003 and 2010 will receive the end product.

    If I manually enter data into A2 (1 to 3) the Checkbox automatically become visible or in-visible as required
    If I use the Dropbox and select an option, this also put a number between 1 and 3 into A2, however the Checkbox remain and does not become invisible etc

    And this is where I require assistance to resolve, please see attached excel file Excel Query.xlsm

    Code I'm using in spreadsheet:

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Me.Range("A2")) Is Nothing Then
    If Target.Value > 1 Then
    Me.Shapes("Check Box 11").Visible = True
    Else
    Me.Shapes("Check Box 11").Visible = False
    End If
    End If

    End Sub
    Attached Files Attached Files
    Last edited by simon@natsow.co.za; 08-29-2013 at 09:07 AM. Reason: add code

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] making a checkbox appear and disappear based on a cell's value
    By yoram in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-12-2021, 11:36 PM
  2. Making a command button and listbox disappear after use
    By benochs1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2013, 12:53 PM
  3. Make a box appear / disappear depending on drop down form selection
    By excelyee in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 02-27-2013, 01:29 PM
  4. Making a button disappear after clicking on it...
    By ssedha in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-26-2012, 01:50 PM
  5. Make a box appear / disappear depending on drop down form selection?
    By simonwilliams in forum Word Formatting & General
    Replies: 0
    Last Post: 03-09-2011, 10:21 AM

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