Originally posted by: Gobadgrs
Originally posted by: Descartes
Labels can't display tabs, so do use Space() instead.
e.g.: yourLabel.Caption = "1" & Space(4) & "2"
Thanks!
maybe you can help me with my next part of the code... it keeps looking for a end of statement and I dont know why
If sentry = True Then 'prevents program crashing from blank values
sludge = sludgeVolume
cost = costPerTon
yearlyDisposal = 52 * sludgeVolume * costPerTon 'Math calculations
yearlySavings = yearlyDisposal * 0.6
Dim output As String
output = "Year" & vbTab & "Yearly Disposal Costs" & vbTab & "Annual Increase in Profits" vbCrLf & _
"1" & Format(yearlyDisposal, "currency") & Format(yearlySavings, "currency") vbCrLf & _
"2" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency") vbCrLf & _
"3" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency") vbCrLf & _
"4" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency") vbCrLf & _
"5" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency") vbCrLf & _
"6" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency") vbCrLf & _
"7" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency") vbCrLf & _
"8" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency") vbCrLf & _
"9" & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency")vbCrLf & _
"10" & vbTab & Format(yearlyDisposal * 1.02, "currency") & Format(yearlySavings * 1.02, "currency")
yearlyDisplay.Text = output
End If