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
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