Show userform without it taking focus?

[leah]

I'm using a modeless userform to display a running set of totals on my
spreadsheet. When I first bring it up using interface.Show, the
userform takes focus, and users think that the spreadsheet has been
locked. Really the cursor has just shifted to the userform, but it's
very annoying. Does anyone know of a way programmatically to shift the
focus back to the underlying spreadsheet? I've tried activating the
sheet and selecting cells using VBA, but none of it returns the focus
to the spreadsheet.

TIA!
Leah

 

[Tom Ogilvy]

Sub ShowForm()
UserForm1.Show 0
AppActivate Application.Caption
End Sub

worked for me.

 

[Leah Kaplan]

That worked! Thanks so much.

Leah