Invalid or Unqualified Reference

**dcompagnone** · 08-13-2010, 05:38 AM

Hi Professionals,

I'm getting the above message when I click cmdUpdateAccount event.

It's highlighting the line 'n = Application.Match(Me.ComboBox1.Value, .Range("A:A"), 0)'

Full code is below incase it's something else in it that may cause a problem.

Basically, the combo box calls the data into the userform and the user can may the relevant changes to the account detail and then 'update' it.

Code in two parts below:

Help appreciated!

Dom

Please Login or Register  to view this content.

**dcompagnone** · 08-13-2010, 05:39 AM

Please Login or Register  to view this content.

**royUK** · 08-13-2010, 06:30 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

**romperstomper** · 08-13-2010, 06:42 AM

Sorry Roy, didn't see your post before I edited the original.

**romperstomper** · 08-13-2010, 06:43 AM

You haven't used a With... End With statement, so it should be:

Please Login or Register  to view this content.

**dcompagnone** · 08-13-2010, 08:45 AM

oh man!

See it's the small things that you miss when you do it late at night.

thank you.

And thanks for editing my code tags in. I thought I hade done those.

Appreciated

Dom