open forms

S

seeker4

Is there a way to have code check to see if a form is open
before is tries to set focus on an object in said form?

seeker4
 
P

Pavel Romashkin

Public Function IsOpen(strName As String) As Boolean
On Error Resume Next
Dim Junk As String
Err.Clear
Junk = Forms(strName).Name
IsOpen = (Err.Number = 0)
Err.Clear
End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How to make scroll bar permanently visible, Word 365 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Create form with checkbox les that expand and collapse sections of the form? 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Bugs in Office 2019 0
Crating User Form to Add Names 1

Top