clear all activeX object values

[Jivo]

Hi all,

I'm looking for some vba script that can clear all values in the activeX objects in my Excel form.

VBAProject.Sheet1.Textbox1.value = ""

Only clears one object at the time and I want to clear all objects...

Any thoughts? thanks.

Ivo

[royUK]

Try this

Please Login or Register  to view this content.