宏不再运行 [英] Macros no longer runs

问题描述

我在Excel电子表格上创建了​​一个用于信息的宏文本框，但它不再运行。我没有更改代码或做了任何其他应该阻碍它操作的东西，所以我不知道是什么。我使用Excel 2016.我已经包含了
评论的代码。这很简单，所以我不知道为什么突然停止了。

I created a macros text box for info on an Excel spreadsheet and it no longer runs. I haven't changed the code or have done anything else that should have hindered it operations so I don't know what's up. I use Excel 2016. I have included the code for review. It is really simple so I don't know why it suddenly stopped.

Sub ShowTextBox()
  UserForm1.TextBox1.Text = "#### - Check Number" & vbLf & "0000 - ACH Transfer" & vbLf & "0001 - ACH Debit" & vbLf & "0002 - ACH Credit" & vbLf & "0003 - ATM Transaction Withdrawal" & vbLf & "0004 - ATM Transaction Deposit" & vbLf & "0005 - Remote Online Deposit" & vbLf & "XXXX - John Debit Card Transaction" & vbLf & "XXXX - Ashley Debit Card Transaction"
  UserForm1.Show vbModeless
End Sub

推荐答案

您好，

这是讨论Microsoft Excel功能的问题和反馈的论坛，我将您的问题转移到MSDN论坛上的Excel

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

https://social.msdn.microsoft.com/Forums/en-US / home？forum = exceldev

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的受访者群体和其他合作伙伴经常阅读论坛的人可以分享他们的知识，也可以从与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

问候，

Emi

这篇关于宏不再运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！