Could not set the value property. Type Mismatch

[katieshields]

Can anyone help. I am trying to populate a text box from the selection in a combo box on a user form. I have a very simple code

Please Login or Register  to view this content.

It keeps giving me the error message "Could not set the value property. Type Mismatch"

Can anyone tell me where I have gone wrong?

Thanks

Katie

[patel45]

maybe, if you attach a sample file

[AlphaFrog]

If the Vlookup function returns an error, then VBA throws an error when it applies the Vlookup error value to the textbox.

Is the lookup value from the combobox a number? If yes, convert it from text to a number in the vlookup formula. The value type from the combobox is text. That could cause the Vlookup to error.

This will convert the combobox value from string to long.

Please Login or Register  to view this content.

[katieshields]

Thank you, I tried that and now it comes back with Syntax error? Any idea what that is?

[AlphaFrog]

Thank you, I tried that and now it comes back with Syntax error? Any idea what that is?

It means you didn't type it in correctly

[AlphaFrog]

I just read your other post. You could have one combobox with two (or more) columns of data. Would that work for you?

[katieshields]

The other code works perfectly now, thanks. I was missing a )

What do you mean one box with columns?

[katieshields]

I do also have another issue now relating to this. The users will also need to input data that isn't necessarily in the pre populated data. There is a field earlier in the form which states new or existing. Is there anyway I can include this into the code? If existing auto populate, if new then a free text option?