combobox.value not working correctly, need help!

**brykarc22** · 07-14-2011, 09:35 AM

I want when the user picks a value from the combobox in the user form for it to find that value in the range the list comes from and then offset it 3 cells over and display a corresponding value. This doesnt seem to be working, when I put an actually value you in for Me.cbo1.Value, say "24" it works perfectly. But the Me.cbo1.Value doesnt seem to be working. Any ideas?

Please Login or Register  to view this content.

**tigeravatar** · 07-14-2011, 10:11 AM

brykarc22,

In the future, please wrap code in code tags. As to your question, assuming the combobox's list is populated using a RowSource, you could use the following:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**royUK** · 07-14-2011, 10:33 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Simple answer available, but add the tags

**brykarc22** · 07-14-2011, 10:37 AM

I copied that code and when I run it I get the error:
Run-time error '1004'
Method 'Range" of object '_Global' failed

**royUK** · 07-14-2011, 10:38 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**brykarc22** · 07-14-2011, 11:26 AM

Okay I changed the one part in the code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

The actual name of the range it came from and it worked perfectly. Im not exactly sure what the error was, and if you have an explaination for the error I'd love to know, but it works perfect now so thank you very much for your help and advice!