maninjapan
10-03-2008, 03:00 AM
Im trying to build a data entry spreadsheet involving P&L in USD, GBP and EUR. Ultimately Id like the proft in USD , (i input the exchange rate)
So far I have the following
If ComboBoxCurrency.Text = "EUR" Or _
ComboBoxCurrency.Text = "GBP" Then
Cells(NextRow, 6) = TextBoxPL.Text And _
Cells(NextRow, 7) = Cells(NextRow, 6) * Cells(NextRow, 5)
Else: Cells(NextRow, 7) = TextBoxPL.Text
End If
All the data comes up as is, except for 7, Obviously this is written incorrectly....
So far I have the following
If ComboBoxCurrency.Text = "EUR" Or _
ComboBoxCurrency.Text = "GBP" Then
Cells(NextRow, 6) = TextBoxPL.Text And _
Cells(NextRow, 7) = Cells(NextRow, 6) * Cells(NextRow, 5)
Else: Cells(NextRow, 7) = TextBoxPL.Text
End If
All the data comes up as is, except for 7, Obviously this is written incorrectly....