When launching the form, use the mode vbModeless
may also help to place the form at the margins of the screen
e.g.
myForm.Show vbModeless

within the form
Sub Userform_Activate
me.left = application.width - me.width - 6
me.top = application.top + 6
End Sub

Note that you cannot Alt-Tab to the form once it loses focus. Instead, the
other application needs to be restored to a size less than full screen so
that your form is visible when the other application has focus. Then use the
mouse to set focus back to the form

Kevin Beckham

"cjmd" wrote:

Is it possible to show a form, task-switch to another application, then
somehow put focus on the form so that it shows but with the other
application in the background, rather than Excel in the background? The
form I am using is generated by a macro assigned to a custom button.

Thanks,
Chris