Userform error

[keith barnes]

Hi Guys

I have been working on a userform for some time now and have finally finished. It does everything i want it to do with some help from fellow forum members.

The problem is now that i cannot get it to work anymore on other machines other than the desktop it was compiled on. I have tried similair machines both 32 and 64 bit with similiar versions of office. I have also tried saving as a macro and binary.

When i go to save the form or clear the contents of the textbox, i get a module error "[Counta(Database!A:A)]". You will see the error (hopefully)

I have attached a copy for desperate aid and assistance please.

Thanks in advance

[Paul_Hossler]

Seems to work OK here

On the failing PCs, you can try to check References

In the VBE, Tools, References. Look for #MISSING

Mine looks like this

Capture.JPG

[snb]

Before distributing I'd suggest to review the whole concept and to remove all redundant code.
E,g. Why using Textboxes in Sheet5 where cells can serve the same purpose ?

Here the missing library is windows common controls-2.6.0