Remove first item in Listbox on form Initialize

[Taemex]

Please Login or Register  to view this content.

I need just the very first item of Listbox1.IndexList to be removed on form.Initialize(). Any suggestions how to do this?

I tried all the following, all with errors:

Please Login or Register  to view this content.

[teylyn]

Don't include it in the list index, maybe?

[Taemex]

I can't because the listbox RowSource is a named range and the named range is an entire column in case the customers add a ton of entries. I had considered using a smaller range which would obviously solve this issue, however I was hoping there'd be an easy fix. After spending the last couple months studying vb.net, I'm discovering there are some things that are so much easier to accomplish in vb.net, or maybe I just have more experience with it now, lol!

[romperstomper]

Simple solutions:
1. Use a dynamic named range (see here)
2. Don't use RowSource at all - populate the control in code.

Unless you want to use column headers, I'd recommend option 2.