title: Excel VBA: Manipulate Shockwave Flash Property
body: <p>I'm working on a little project to make a 'memeplayer' in Excel with YouTube videos - here's a screenshot of the spreadsheet</p>
  
  <p><a href="https://imgur.com/pETOo" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CmVVf.png" alt="http://imgur.com/pETOo"></a></p>
  
  <p>The code I'm attempting to use is below:</p>
  
  <pre><code>Option Explicit
  Sub PlaySamsMemes()
  
  Dim sChosenTitle As String
  Dim rngVideoData As Range
  Dim lFinalRow As Long
  Dim sLookupValue As String
  
  lFinalRow = Range("C65536").End(xlUp).Row
  sChosenTitle = Range("F4").Value
  Set rngVideoData = Range("B2:C" &amp; lFinalRow)
  sLookupValue = Application.VLookup(sChosenTitle, rngVideoData, 2, False)
  
  Memeplayer.SetVariable("Movie", sLookupValue)
  
  End Sub
  </code></pre>
  
  <p>I'd be really grateful if you could tell me how to get the script to play nice with the embedded Shockwave Flash that I've named 'Memeplayer' in the Excel interface. The line I'm using to try and make it run is:</p>
  
  <p>Memeplayer.SetVariable("Movie", sLookupValue)</p>
  
  <p>but it just returns an 'Object required' error (Runtime Error 424). I've not worked with shapes and objects much as yet and I've no idea how to fix it. Help me please!</p>