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

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