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
|