Results 1 to 3 of 3

View hidden pictures based on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    TOLEDO,OHIO
    MS-Off Ver
    7
    Posts
    4

    View hidden pictures based on cell value

    I HAVE WRITTEN SOME BASIC CODE TO MAKE THIS HAPPEN...HOWEVER I HAVE OVER 1000 CELLS THAT NEED THE SAME THING. I NEED A WAY TO SHORTEN THE PROCESS AND CANNOT FIGURE OUT HOW TO CODE THIS. I AM VERY NEW TO CODING. THIS IS A SAMPLE OF THE CODE I AM USING

    HideSignals
    Select Case [T11]
    Case 1: Shapes("YELLOW1").Visible = msoTrue
    Case 2: Shapes("GREEN1").Visible = msoTrue
    Case 3: Shapes("FUSHA1").Visible = msoTrue
    Case 4: Shapes("BROWN1").Visible = msoTrue
    End Select
    Select Case [U11]
    Case 1: Shapes("YELLOW3").Visible = msoTrue
    Case 2: Shapes("GREEN3").Visible = msoTrue
    Case 3: Shapes("FUSHA3").Visible = msoTrue
    Case 4: Shapes("BROWN3").Visible = msoTrue
    End Select
    Select Case [V11]
    Case 1: Shapes("YELLOW4").Visible = msoTrue
    Case 2: Shapes("GREEN4").Visible = msoTrue
    Case 3: Shapes("FUSHA4").Visible = msoTrue
    Case 4: Shapes("BROWN4").Visible = msoTrue
    End Select
    Select Case [W11]
    Case 1: Shapes("YELLOW2").Visible = msoTrue
    Case 2: Shapes("GREEN2").Visible = msoTrue
    Case 3: Shapes("FUSHA2").Visible = msoTrue
    Case 4: Shapes("BROWN2").Visible = msoTrue
    End Select
    End Sub
    
    Sub HideSignals()
    Dim i As Integer
    For i = 1 To 15
    Shapes("YELLOW" & i).Visible = msoFalse
    Shapes("GREEN" & i).Visible = msoFalse
    Shapes("FUSHA" & i).Visible = msoFalse
    Shapes("BROWN" & i).Visible = msoFalse
    Next i
    End Sub
    
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, [T11:AH11]) Is Nothing Then
    Worksheet_Calculate
    End If
    End Sub
    Last edited by t9021rk; 05-04-2015 at 09:32 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-11-2015, 06:22 PM
  2. How to view pictures with access
    By Ranbir in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-17-2009, 12:25 AM
  3. [SOLVED] column is hidden in normal view but not print view
    By Bianca in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2006, 03:45 AM
  4. [SOLVED] All pictures disappear from my whole excel file when I use 'hidden
    By greencecil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2005, 05:30 AM
  5. help understanding code and finding hidden pictures
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2005, 01:54 PM

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