milton,
Adicione um botão e no evento Click dele, adicione o código abaixo :
Código: Selecionar todos
For b = 0 To ListBox1.ListCount - 1
ListBox1.Selected(b) = True
Select Case b
'De D9 á D15
Case Is = 0
ThisWorkbook.Sheets("Plan2").Range("D9") = ListBox1.Value
Case Is = 1
ThisWorkbook.Sheets("Plan2").Range("D10") = ListBox1.Value
Case Is = 2
ThisWorkbook.Sheets("Plan2").Range("D11") = ListBox1.Value
Case Is = 3
ThisWorkbook.Sheets("Plan2").Range("D12") = ListBox1.Value
Case Is = 4
ThisWorkbook.Sheets("Plan2").Range("D13") = ListBox1.Value
Case Is = 5
ThisWorkbook.Sheets("Plan2").Range("D14") = ListBox1.Value
Case Is = 6
ThisWorkbook.Sheets("Plan2").Range("D15") = ListBox1.Value
'De G9 á G15
Case Is = 7
ThisWorkbook.Sheets("Plan2").Range("G9") = ListBox1.Value
Case Is = 8
ThisWorkbook.Sheets("Plan2").Range("G10") = ListBox1.Value
Case Is = 9
ThisWorkbook.Sheets("Plan2").Range("G11") = ListBox1.Value
Case Is = 10
ThisWorkbook.Sheets("Plan2").Range("G12") = ListBox1.Value
Case Is = 11
ThisWorkbook.Sheets("Plan2").Range("G13") = ListBox1.Value
Case Is = 12
ThisWorkbook.Sheets("Plan2").Range("G14") = ListBox1.Value
Case Is = 13
ThisWorkbook.Sheets("Plan2").Range("G15") = ListBox1.Value
'De D20 á D26
Case Is = 14
ThisWorkbook.Sheets("Plan2").Range("D20") = ListBox1.Value
Case Is = 15
ThisWorkbook.Sheets("Plan2").Range("D21") = ListBox1.Value
Case Is = 16
ThisWorkbook.Sheets("Plan2").Range("D22") = ListBox1.Value
Case Is = 17
ThisWorkbook.Sheets("Plan2").Range("D23") = ListBox1.Value
Case Is = 18
ThisWorkbook.Sheets("Plan2").Range("D24") = ListBox1.Value
Case Is = 19
ThisWorkbook.Sheets("Plan2").Range("D25") = ListBox1.Value
Case Is = 20
ThisWorkbook.Sheets("Plan2").Range("D26") = ListBox1.Value
'De G20 á G26
Case Is = 21
ThisWorkbook.Sheets("Plan2").Range("G20") = ListBox1.Value
Case Is = 22
ThisWorkbook.Sheets("Plan2").Range("G21") = ListBox1.Value
Case Is = 23
ThisWorkbook.Sheets("Plan2").Range("G22") = ListBox1.Value
Case Is = 24
ThisWorkbook.Sheets("Plan2").Range("G23") = ListBox1.Value
Case Is = 25
ThisWorkbook.Sheets("Plan2").Range("G24") = ListBox1.Value
Case Is = 26
ThisWorkbook.Sheets("Plan2").Range("G25") = ListBox1.Value
Case Is = 27
ThisWorkbook.Sheets("Plan2").Range("G26") = ListBox1.Value
End Select
Next
Me.ListBox1.ListIndex = 0
Apenas altere a planilha onde quer que os dados sejam transferidos (Plan2 para a que deseja).
Abs