Thread: Populating list box with number format data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_375_] Leith Ross[_375_] is offline
external usenet poster
  
Posts: 1
Default Populating list box with number format data

Hello Francis,

To load the ListBox with the data as it appears in the cell, change

.AddItem cell.value

To

.AddItem cell.text

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=49291

Reply With QuoteReply With Quote