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.

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

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=56508