ws column range to listbox

I can get ListBox1 to populate, but lost on the rest.
On UF_Initialize ListBox1 is populated with the sheet names from Expedites.xls
On ListBox1_Click I would like to go to that sheet name and populate Listbox2 with C2:C from the sheet selected?
Then on CommandButton1_Click select the row ListBox2's value is from, highlight the row A:O yellow and delete the value in M for that row.


Any help would be appreciated.

Thanks,

Kurt


Example:

LB1 has Jun 04, Jul 04, Aug 04, Sep 04 in it.

Jul 04 is selected.

Range C2:C shows in LB2 from sheet Jul 04.

15240 is selected in LB2 (which is row 25 of sheet Jul 04)

Row 25 (A:O) from sheet Jul 04 is highlighted yellow and m25 value is deleted.


Private Sub UserForm_Initialize()
Dim Ws As Worksheet
Me.ListBox1.Clear
Workbooks.Open ("F:\Customer Service\Expedites.xls")
For Each Ws In ActiveWorkbook.Worksheets
Me.ListBox1.AddItem Ws.Name
Next Ws
End Sub