Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format question
Using the code- Dim newColl As New Collection [mycode] For Each Item In newColl UserForm5.PPTListBox.AddItem Item Next Item I am adding dollar amounts (like 24.50 as a string) to the PPTListBox. If the dollar amount is 24.00 then 24 shows in the listbox (24.50 shows as 24.5). Is the problem with not formatting the "Item" when it is added? How can I correct this? Thanks. -- ricksimm ------------------------------------------------------------------------ ricksimm's Profile: http://www.excelforum.com/member.php...o&userid=21892 View this thread: http://www.excelforum.com/showthread...hreadid=377140 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format question
maybe...
UserForm5.PPTListBox.AddItem format(Item,"0.00") ricksimm wrote: Using the code- Dim newColl As New Collection [mycode] For Each Item In newColl UserForm5.PPTListBox.AddItem Item Next Item I am adding dollar amounts (like 24.50 as a string) to the PPTListBox. If the dollar amount is 24.00 then 24 shows in the listbox (24.50 shows as 24.5). Is the problem with not formatting the "Item" when it is added? How can I correct this? Thanks. -- ricksimm ------------------------------------------------------------------------ ricksimm's Profile: http://www.excelforum.com/member.php...o&userid=21892 View this thread: http://www.excelforum.com/showthread...hreadid=377140 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Question | Excel Discussion (Misc queries) | |||
Format % Question | Excel Worksheet Functions | |||
Format Question | Excel Worksheet Functions | |||
Format Question Please | Excel Discussion (Misc queries) | |||
Format question | Excel Programming |