For Each frm In VBA.UserForms
Unload frm
Next frm

You can get the names of each of the forms using frm.name

"dunnerca" wrote:

I've searched all over and cannot find an example of coding that will close
all open user forms. I'm thinking something like

For i = 1 To Controls("msforms").Count
Unload ?
Next

As you can see, that's a really rough estimate of what's needed.