Question re: VBA ComboBox with many items

[leopardhawk]

Hello forum friends, can anyone suggest the best way to code a ComboBox in VBA that would potentially have a few hundred items in it?? It will be for users to select a year, starting say with 1930 and going as high as 2230.

I'm just not sure whether 'array' or 'additem' would be better or maybe I should be looking at some other alternative, like a text box with a spinner on it???

Hoping for ideas! Thanks!

 

[leopardhawk]

okay, I can do that, I changed the order (not) thinking that it would make a difference and I also have cell E9 formatted for long-date (month/day/year) so I thought it would work from a logical perspective. Sorry about that.

Should I change that setting back to whatever it was before (can't remember)...???

I will try your suggestions and report back! Thanks for your patience.

 

[Norie]

Have you tried DateSerial?

 

[leopardhawk]

I changed the line of code to "Dob = DateSerial(Me.YearComboBox, Me.MonthComboBox, Me.DayComboBox)"

Still getting the run-time 13 type-mismatch error when I try and use the form...

 

[Fluff]

Have you tried DateSerial?

Have you looked at what I suggested, or what the OP posted in post#19?

 

[Fluff]

Is it that line that is causing is getting highlighted?

 

[leopardhawk]

@Fluff yes, it is highlighted in yellow...

 

[Norie]

Fluff

I'm sorry if I've missed something - since the changes to the site all I can see when I first click on the thread are posts #1. #21, #22, #23 and #24

 

[Fluff]

@Fluff yes, it is highlighted in yellow...

Do all three combos have a value & do they equate to a real date, ie you haven't select month 2 & day 31

 

[leopardhawk]

@Fluff sorry for being such a NOOB... I get the error when I try and launch the userform so no, the combos are empty (other than the 'items' that will show in them when the user clicks the down-arrow. I can't even get to them to select a date. Is this what you mean??

 

[Fluff]

How and when is that code being run?