ComboBox, DropDownListOnly, Range.Find Method Issue

[s2jrchoi]

All,

I have a userform to edit transactions in a database. I use the Range.Find Method to find the transactions to edit. This userform has many textboxes and a bunch of ComboBoxes. However there is one particular ComboBox that is giving me a headache; the ComboBox that lists years (2012 - 2030) which is pulled from a table on a spreadsheet. All my ComboBoxes are set to "Style: 2 - fmStyleDropDownList." .

The issue I have is that when I use the Range.Find Method to load values from the database, the only field that doesn't populate with any value is.the ComboBox field with the year? However, when I set the style to fmStyleDropDownCombo, the values now show? Why is that? I can't set the style to Combo because I don't want the user to type in any random value. I want them to only select a year ex: 2014. What can I do to make this work?

Please let me know your thoughts on this.

Thank you!

J

[Norie]

How are you populating the combobox?

[s2jrchoi]

Hi Norie,

Please see the code below. I removed the non-essential parts.

Please Login or Register  to view this content.

[Norie]

That looks fine, how are you putting the value into the year combobox?

[s2jrchoi]

Please see below. Again, I removed all the fluff. What do you think could be wrong with it?

Please Login or Register  to view this content.

[Norie]

What happens if you remove On Error Resume Next?

[s2jrchoi]

My userform doesn't load. I get a Run-time error '380': Could not set the Value property. Invalid property value.

[Norie]

Is that error happening in the code you posted?

If it is it's not really what I was expecting if my thinking was right.

What I was thinking was that Find might be failing to find idNum which would, because of the On Error..., mean byear would never get a value.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[s2jrchoi]

Unfortunately, I can't send the entire workbook due to the data but I just made a very simple userform (took under 5 minutes) with the issue that I have. Please see attached.

[Norie]

I really can't see what the problem is but I did find a workaround, of sorts.

Please Login or Register  to view this content.

[s2jrchoi]

That worked! Thank you for your help!!!!! I will mark this as solved!