When I create a module in VBA and I'm typing a line of code, it just closes, any solutions?

Nathanael Andrade 0 Reputation points
2024-07-04T21:01:09.3766667+00:00

I'm creating a simple registration system in Excel, I open Visual Basic normally, but when I click on "insert" and then "Module", after 10s Excel closes.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,657 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,426 Reputation points Microsoft Vendor
    2024-07-05T07:03:52.15+00:00

    Hi,

    Did this problem appear in all Excel Workbooks or specific Workbook?

    How about other Office product with VBA editor?

    I suggest you try to repair Office, try to repair online:

    https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.