Excel VBA Refresh a UserForm from another UserForm command button
<p>I currently have UserForm1 that contains multipage and a listbox.  The listbox essentially shows a range of data from the excel sheet itself.</p>

<p>I have set up Userform2 as a popup to fill in information that is added to the excel sheet which is then displaced in the listbox in Userform1.</p>

<p>In essence the user navigates to the listbox, clicks a command button, a popup appears and the user complete the information, clicks "ok" and it it is then displayed in the listbox.</p>

<p>The issue I have is that I am unable to get the listbox up refresh when the user clicks "ok".</p>

<p>The code I have in the "ok" command button is:</p>

<pre><code>    Private Sub CommandButton1_Click()


 Dim LastRow As Long, ws As Worksheet

    Set ws = Sheets("Exchange")

    LastRow = ws.Range("A" &amp; Rows.Count).End(xlUp).Row + 1

    ws.Range("A" &amp; LastRow).Value = TextBox1.Text
    ws.Range("B" &amp; LastRow).Value = TextBox2.Text
    ws.Range("F" &amp; LastRow).Value = TextBox3.Text
    ws.Range("G" &amp; LastRow).Value = TextBox4.Text
    ws.Range("E" &amp; LastRow).Value = TextBox5.Text
    ws.Range("H" &amp; LastRow).Value = ComboBox1.Text





UserForm2.Hide

Forms!UserForm1.ListBox1.Requery
Forms!UserForm1.Repaint


End Sub
</code></pre>

<p>I currently get Run-time error '424' Object required.</p>

<p>Any suggestions on how I can refresh?</p>

<p>Many thanks</p>