ListBox - start at the right line

[olio39]

Hi

I have the Listbox with many values. Then I would like to put in the Worsheet in Cell (for example A1) the number. After the ListBox is opened I would like that it the nearest value to the A1 is marked - this is where it starts.

For example: in the A1 I put value 50. And in the Listbox there are many numbers and I would like that the nearest value to the 50 (Cell A1) is marked.

Anybody knows how to do it?

Thanks for each advise.
Have a nice day.

[Simon Lloyd]

Put this in your userform module:

Please Login or Register  to view this content.

this looks at the value in B1 and looks up the nearest value to it without exceeding the value,the range is where i had my numbers but you could replace this for a named range, i tried numerous different methods and came up with a clumsy one, however this was supplied by Charlize at another forum.

Regards,
SImon

[olio39]

Thanks a lot. It works perfect. I will have to study some more to understand this, but I am glad I can use it.

Thanks again.