Coutinho,
Resolvido
consegui assim, calculando no excel e com o código abaixo eu importei os valores para o meu formulário.
E também usei o código que vc passou pra mim, no rodapé do formulário para analisar a última entrada de material
obrigado
amigo
[Private Sub cboUsina_click()
Dim proximoId As Long
' A LINHA ABAIXO DETERMINA A PLAN14 (ResCAP) COMO SELECIONADA
ActiveWorkbook.Sheets("ResCAP").Activate
Range("B3").Value = CStr(cboUsina.Text)
Set wsCadastro = ThisWorkbook.Worksheets("ResCAP")
Dim strTotal As Double
'Trata Entrada de CAP
Me.lblJanEntrada.Caption = Format(Plan14.Range("C6").Value, "#,##0.00")
Me.lblFevEntrada.Caption = Format(Plan14.Range("C7").Value, "#,##0.00")
Me.lblMarEntrada.Caption = Format(Plan14.Range("C8").Value, "#,##0.00")
Me.lblAbrEntrada.Caption = Format(Plan14.Range("C9").Value, "#,##0.00")
Me.lblMaiEntrada.Caption = Format(Plan14.Range("C10").Value, "#,##0.00")
Me.lblJunEntrada.Caption = Format(Plan14.Range("C11").Value, "#,##0.00")
Me.lblJulEntrada.Caption = Format(Plan14.Range("C12").Value, "#,##0.00")
Me.lblAgoEntrada.Caption = Format(Plan14.Range("C13").Value, "#,##0.00")
Me.lblSetEntrada.Caption = Format(Plan14.Range("C14").Value, "#,##0.00")
Me.lblOutEntrada.Caption = Format(Plan14.Range("C15").Value, "#,##0.00")
Me.lblNovEntrada.Caption = Format(Plan14.Range("C16").Value, "#,##0.00")
Me.lblDezEntrada.Caption = Format(Plan14.Range("C17").Value, "#,##0.00")
'Soma Entrada
Me.lblSomaEnt.Caption = Format(Plan14.Range("C18").Value, "#,##0.00")
'Trata Saída de CAP
Me.lblJanSaida.Caption = Format(Plan14.Range("D6").Value, "#,##0.00")
Me.lblFevSaida.Caption = Format(Plan14.Range("D7").Value, "#,##0.00")
Me.lblMarSaida.Caption = Format(Plan14.Range("D8").Value, "#,##0.00")
Me.lblAbrSaida.Caption = Format(Plan14.Range("D9").Value, "#,##0.00")
Me.lblMaiSaida.Caption = Format(Plan14.Range("D10").Value, "#,##0.00")
Me.lblJunSaida.Caption = Format(Plan14.Range("D11").Value, "#,##0.00")
Me.lblJulSaida.Caption = Format(Plan14.Range("D12").Value, "#,##0.00")
Me.lblAgoSaida.Caption = Format(Plan14.Range("D13").Value, "#,##0.00")
Me.lblSetSaida.Caption = Format(Plan14.Range("D14").Value, "#,##0.00")
Me.lblOutSaida.Caption = Format(Plan14.Range("D15").Value, "#,##0.00")
Me.lblNovSaida.Caption = Format(Plan14.Range("D16").Value, "#,##0.00")
Me.lblDezSaida.Caption = Format(Plan14.Range("D17").Value, "#,##0.00")
'Soma Saída
Me.lblSomaSaida.Caption = Format(Plan14.Range("D18").Value, "#,##0.00")
'Trata Saldo de CAP
Me.lblJanSaldo.Caption = Format(Plan14.Range("F6").Value, "#,##0.00")
Me.lblFevSaldo.Caption = Format(Plan14.Range("F7").Value, "#,##0.00")
Me.lblMarSaldo.Caption = Format(Plan14.Range("F8").Value, "#,##0.00")
Me.lblAbrSaldo.Caption = Format(Plan14.Range("F9").Value, "#,##0.00")
Me.lblMaiSaldo.Caption = Format(Plan14.Range("F10").Value, "#,##0.00")
Me.lblJunSaldo.Caption = Format(Plan14.Range("F11").Value, "#,##0.00")
Me.lblJulSaldo.Caption = Format(Plan14.Range("F12").Value, "#,##0.00")
Me.lblAgoSaldo.Caption = Format(Plan14.Range("F13").Value, "#,##0.00")
Me.lblSetSaldo.Caption = Format(Plan14.Range("F14").Value, "#,##0.00")
Me.lblOutSaldo.Caption = Format(Plan14.Range("F15").Value, "#,##0.00")
Me.lblNovSaldo.Caption = Format(Plan14.Range("F16").Value, "#,##0.00")
Me.lblDezSaldo.Caption = Format(Plan14.Range("F17").Value, "#,##0.00")
'SALDO DE CAP
Me.lblSaldo.Caption = Format(Plan14.Range("F18").Value, "#,##0.00")
'SALDO DE CAP ANTERIOR
Me.lblSaldoAnterior.Caption = Format(Plan14.Range("D3").Value, "#,##0.00")
Ennd Sub]