Results 1 to 2 of 2

Arrow on drop down menu disappear (excel 2010) 2 SAMPLES PICT FOR TESTING (C:\COLOUR\)

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    SYDNEY
    MS-Off Ver
    2010
    Posts
    2

    Arrow on drop down menu disappear (excel 2010) 2 SAMPLES PICT FOR TESTING (C:\COLOUR\)

    Sub PICTURE()
    
    Dim Sh As Shape
        With Worksheets("Sheet1")
            For Each Sh In .Shapes
                'If Not Application.Intersect(Sh.TopLeftCell, .Range("G15:J29")) Is Nothing Then
                    Sh.Delete
                'End If
            Next Sh
        End With
        
               
        Dim picname As String
     
        picname = Range("H7") 'This is the picture name
    
        Range("G15").Select 'This is where picture will be inserted
    
        ActiveSheet.Pictures.Insert("C:\COLOUR\" & picname & ".jpg").Select 'Path to where pictures are stored
    
    ' This resizes the picture
    
    With Selection
    .Left = Range("G15").Left
    .Top = Range("G15").Top
    .ShapeRange.LockAspectRatio = msoFalse
    .ShapeRange.Height = 180#
    .ShapeRange.Width = 192#
    .ShapeRange.Rotation = 0#
    End With
    
        
    Range("H7").Select
    Application.ScreenUpdating = True
    
    
    End Sub
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by FDibbins; 09-23-2015 at 10:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. drop down menu arrow disappeared
    By ahmadabbasia in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-09-2014, 08:25 AM
  2. Drop down menu/ filter by colour
    By ljw89 in forum Excel General
    Replies: 1
    Last Post: 06-11-2013, 08:05 AM
  3. Replies: 0
    Last Post: 02-20-2013, 10:00 AM
  4. Hypothesis Testing: Two samples
    By whatwhatwhat in forum Excel General
    Replies: 2
    Last Post: 07-26-2012, 09:15 PM
  5. Drop down Menu - change of colour
    By bengaluru in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-27-2006, 04:26 PM
  6. [SOLVED] Drop down menu-colour of the text
    By MGC in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-10-2005, 09:06 AM
  7. [SOLVED] Drop down arrow disappear
    By broogle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2005, 09:06 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