So, individuals can create a link from the command button to a worksheet in your workbook. In this tutorial, we will explain how to use the Command button to navigate between worksheets in Excel.

Click the command button you created on the form. VB6 sends the data from the form to a new Excel spreadsheet using the file name you entered in the code.