Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What I have read is that there is no advantage to using the $ versions of the
function in current versions of VBA. (implications are that they executed the same). ? typename(Format$(.23, "0.00%")) String ? typename(Format(.23, "0.00%")) String -- Regards, Tom Ogilvy "Rick Rothstein (MVP - VB)" wrote: TextBox6.Value = Format(Cells(290, 3), "##0.00%") Try it this way... TextBox6.Text = Format$(Cells(290, 3), "0.00%") Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TextBox format? | Excel Discussion (Misc queries) | |||
Calculating a percenatge based on dates | Excel Worksheet Functions | |||
percenatge increase in values across multiple cells | New Users to Excel | |||
textbox format | Excel Programming | |||
TextBox Format | Excel Discussion (Misc queries) |