View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default extended List box

Create a list with the numbers you want to select from on a worksheet.
Give this list a named range. I think it needs to be a workbook named
range, rather than a worksheet named range.
When you do the data validation, enter = LIST (or whatever you've named your
range).

Let me know if you need any more assistance.

"Ken Williams" wrote:

Hi,
I need to be able to choose from a List of numbers 30.00 through 32.00. Such
as 30.00,30.01,30.02......
I tried a List box but it only holds 40 selections. Is there such a thing as
an "extended" List box that will hold 200 digits? This is only for my
personal use so anything will do.
Thank you.
Ken Williams