<div>
Check the properties of the User Form. ShowModal property needs to be set to True for it to keep focus until it is closed. <a href="https://filedb.experts-exchange.com/incoming/2023/06_w25/1620419/1687512947294.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2023/06_w25/1620419/1687512947294.png" class="fr-fic fr-dib"></a> <a href="https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/showmodal-property" rel="ugc">ShowModal property (Visual Basic for Applications) | Microsoft Learn</a>
</div>

1687512947294.png

Get'er done !

sidwelle

President / Owner CARDA Consultants Inc.

Daniel Pineault

<div>
That appears to have worked. &nbsp;I had that set to Non-Modal so that I could get behind the form and look at the worksheet if I needed to after the form was loaded. &nbsp; 
 
I guess the users will have to stop and app if they want to look up values from the WS. 
 
Thanks 

</div>

<div>
you'd have to post your workbook for us to take a closer look at.
</div>

<div>
<div class="content wysiwyg-content fr-view">
VBA UserForm looses focus. I have developed a few Macros/applications in VBA that make use of a UserForm.Problem:&nbsp; During testing I find that after I start application, the form looses focus and/or minimizes or a worksheet from the workbook takes focus. &nbsp;Form is no longer in view !Either way, the form is still alive and normalized, I just have to go hunting for it.The form does not show an Icon in the taskbar, so I usually find it by clicking on one of the worksheets that are open from the taskbar and it shows up w/focus in front of one of the Worksheet(s). Can anyone shed light on why it is doing this ?Thanks 
</div>
</div>


VBA UserForm looses focus.
I have developed a few Macros/applications in VBA that make use of a UserForm.
Problem:
  During testing I find that after I start application, the form looses focus and/or minimizes or a worksheet from the workbook takes focus.  Form is no longer in view !
Either way, the form is still alive and normalized, I just have to go hunting for it.
The form does not show an Icon in the taskbar, so I usually find it by clicking on one of the worksheets that are open from the taskbar and it shows up w/focus in front of one of the Worksheet(s).
Can anyone shed light on why it is doing this ?
Thanks


Check the properties of the User Form. ShowModal property needs to be set to True for it to keep focus until it is closed.
ShowModal property (Visual Basic for Applications) | Microsoft Learn

That appears to have worked.  I had that set to Non-Modal so that I could get behind the form and look at the worksheet if I needed to after the form was loaded.  

I guess the users will have to stop and app if they want to look up values from the WS.

Thanks



you&#39;d have to post your workbook for us to take a closer look at.

VBA Userform looses focus to worksheet in Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Golang, also called Go, is an open source programming language that is a statically-typed language with syntax loosely derived from C, adding automatic memory management, type safety, some dynamic-typing capabilities, additional built-in types such as variable-length arrays and key-value maps, and a large standard library. Go is a general-purpose systems programming language that aims to be efficient both for development and execution with a focus on fast compilation and increased maintainability of large projects. Go was originally targeted at systems programming tasks such as building server/web applications, high throughput middleware and databases.

Golang

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.