title: MS Word VBA, trying to populate a combobox with data from an http call
body: <p>I'm using the following code to populate a combobox in Word 2003. </p>
  
  <pre><code>Private Sub UserForm_Initialize()
  ComboBox1.List = Array("Red", "Green", "Yellow", "Blue")
  End Sub
  </code></pre>
  
  <p>What I would like to do is get the data dynamically via an http call. This other function seems to work to get data via http</p>
  
  <pre><code>Dim MyRequest As Object
  
  Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
  MyRequest.Open "GET", _
  "http://localhost:8500/test7.htm"
  
  ' Send Request.
  MyRequest.Send
  
  'And we get this response
  MsgBox MyRequest.ResponseText
  </code></pre>
  
  <p>test7.htm just contains </p>
  
  <pre><code>"Red", "Green", "Yellow", "Blue"
  </code></pre>
  
  <p>I was hoping to combine the two but below doesn't work</p>
  
  <pre><code>Private Sub UserForm_Initialize()
  Dim MyRequest As Object
  
  Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
  MyRequest.Open "GET", _
  "http://localhost:8500/test7.htm"
  
  ' Send Request.
  MyRequest.Send
  
  
  ComboBox1.List = Array(MyRequest.ResponseText)
  End Sub
  </code></pre>
  
  <p>Any help for a VBA noob appreciated</p>