Listbox2 is populated from worksheet R1 which is formatted as currency (£) to 2 decimal places. Listbox2 displays the result with 4 decimal places. Is there further code I can add to this so that Listbox2 displays the result with only 2 decimal places?
Please Login or Register to view this content.
Last edited by zimbo109; 10-04-2010 at 11:37 AM.
Try This
Please Login or Register to view this content.
Your description is that you are getting values from worksheet R1, but your code shows that you are accumulating values from 11 different worksheets.
If it were one worksheet, I would suggest that you set the ListFillRange property of the listbox to the range you want values from, instead of loading them in code.
In the code you have provided, you are loading the actual values, regardless of how they are formatted in the cells. I would suggest you use
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks Dave, works! but the code changes the bit 0.00 to 0# and I lose all decimal places??
Please Login or Register to view this content.
Thanks 6 string - works a treat.
Why two ListBoxes?
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks