Cant find project or library

[Guest]

whats wrong with this code:

For Each c In Me.Controls
If TypeOf c Is msforms.TextBox Then c.Text = ""
If TypeOf c Is msforms.ComboBox Then c.Text = ""
Next

... was working fine but now gives the above error message on execution.

Appreciate all help.

 

[ilyaskazi]

Try this:

Go to menu: Tools-> Macro-> Visual Basic Editor
(or use shortcut key: ALT+F11)

In your editor now go to menu: Tools-> References...
Upon clicking 'References...' , References - MenuToolbar box wil
pop-up.

In Available references, uncheck those all boxes which names star
with
'Missing' and click button OK.

Try running your macro again and see whether helps.

Cheers
ilyaskaz