Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I do this coding in VBA:
================================================== ======= If txtDmdPeak.Text <= txtDtotal.Text Then 'Firm - Normal Bill If Answer = True Then If txtCalculatedDemand.Text < txtDsbf.Text Then txtFirmStandbyCharge.Text = (txtDsbf.Value - txtCalculatedDemand.Value) * txtMaxDmcFirm.Value If txtFirmStandbyCharge.Value = "" Then txtFirmStandbyCharge.Value = "0" Else txtFirmStandbyCharge.Value = Format (txtFirmStandbyCharge.Value, "######.##") End If End If If txtDsbf.Text < txtCalculatedDemand.Text Then If txtCalculatedDemand.Text < txtDtotal.Text Then txtFirmStandbyCharge.Text = (txtDtotal.Value - txtCalculatedDemand.Value) * txtMaxDmcNonFirm.Value If txtFirmStandbyCharge.Text = "" Then txtFirmStandbyCharge.Text = "0" Else txtFirmStandbyCharge.Value = Format (txtFirmStandbyCharge.Value, "######.##") End If End If End If ================================================== ====== It does not display the results on the screen for this particular textbox. Is there anything wrong with the properties which I set? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
my excel sheet is not displayed but black screen appears | Excel Discussion (Misc queries) | |||
Setting hyperlinked cells to be displayed at the top of the screen | Excel Discussion (Misc queries) | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
Why do cells in Excel print shorter than displayed on-screen? | Excel Discussion (Misc queries) | |||
Amount of Data in a Cell Displayed On Screen/Print | Excel Discussion (Misc queries) |