<div>
Can you upload your file so that we are able to have a look.
</div>


Can you upload your file so that we are able to have a look.

<div>
<div class="content wysiwyg-content">
I have a 2016 Macro Enabled workbook with 6 worksheets, 5 of which have list boxes on them. &nbsp;I have a VBA procedure call &quot;Reset&quot; that clears the data on all the worksheets including the list boxes and returns the user to the starting worksheet. &nbsp;This procedure is called when the workbook is closed and when the user clicks a command button on the first sheet. &nbsp;The problem is when the user clicks the command button, all of the list boxes from each worksheet appear on top of each other on the starting worksheet. &nbsp;If you then click through each of the worksheets in the workbook or close and reopen the workbook, everything will go back to normal. &nbsp;Is there some way to stop this from happening?<br />
<br />
Thanks for your help.
</div>
</div>


I have a 2016 Macro Enabled workbook with 6 worksheets, 5 of which have list boxes on them.  I have a VBA procedure call "Reset" that clears the data on all the worksheets including the list boxes and returns the user to the starting worksheet.  This procedure is called when the workbook is closed and when the user clicks a command button on the first sheet.  The problem is when the user clicks the command button, all of the list boxes from each worksheet appear on top of each other on the starting worksheet.  If you then click through each of the worksheets in the workbook or close and reopen the workbook, everything will go back to normal.  Is there some way to stop this from happening?

Thanks for your help.

listbox problems in Excel 2016

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.

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

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

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.