vba和宏_保留有关Excel公式和宏的注释

vba和宏

Do you keep notes about the Excel formulas and macros that you create? What's your documentation system, if you have one? Is it fancy or simple, and is it electronic or paper-based? Or is it all stored in your head?

您是否保留有关创建的Excel公式和宏的注释？ 如果有的话，您的文件系统是什么？ 是花式还是简单，是电子还是纸质？ 还是全部存储在您的脑海中？

保留Excel注释 (Keeping Excel Notes)

A couple of months ago, I got an email from Paul Hanson, who runs Westport Consulting, in Melbourne, Australia.

几个月前，我收到了来自澳大利亚墨尔本的Westport Consulting运营商Paul Hanson的电子邮件。

Paul has created a couple of 8.5" x 11" paper notebooks for spreadsheet users.

Paul为电子表格用户创建了几个8.5“ x 11”纸质笔记本。

• There are 4 index sheets at the front of the notebook, where you can list each formula or function and its page number, after you enter notes about it.
  笔记本电脑的正面有4个索引表，您可以在输入有关公式或函数的注释后列出每个公式或函数及其页码。
• Then there are 100 nicely-structured pages for your formula and function notes.
  然后有100个结构良好的页面，用于您的公式和函数注释。

Here's a sample page from one of the notebooks. I like the clean, well-organized layout for the note pages.

这是其中一个笔记本的示例页面。 我喜欢笔记页面的整洁，井井有条的布局。

我的Excel Notes系统 (My Excel Notes System)

Paul offered to send me sample copies of his Excel notebooks, but I declined his offer, with thanks.

保罗提议给我发送他的Excel笔记本的样本副本，但是我谢绝了他的提议。

Instead of using paper, here's what I do:

我不使用纸张，而是这样做的：

• Excel formula notes are stored in Notepad++ or in Excel workbooks, where I can do a digital search later.
  Excel公式注释存储在Notepad ++或Excel工作簿中，以后可以在其中进行数字搜索。
• Favourite macros are stored in my "DebraMacros" file (xlam format), where I can always find and use them.
  最喜欢的宏存储在我的“ DebraMacros”文件(xlam格式)中，我可以在其中始终找到并使用它们。
• Most macros have comments, to explain the steps, and I always hope that future me understands them!
  大多数宏都有注释，以解释这些步骤，我始终希望将来我能理解它们！

• For some formulas and macros, I make blog posts, or pages on my Contextures website. Later, Google can help me find those!

  对于某些公式和宏，我在Contextures网站上 发布了博客文章或页面 。 以后，Google可以帮助我找到这些！

您是否保留纸质便笺？ (Do You Keep Paper Notes?)

Even though I don't keep paper notes about Excel formulas, lots of people probably do.

即使我不保留有关Excel公式的纸质笔记，很多人也可能这样做。

Do you keep paper notes about your Excel formulas or custom functions, or your macros?

您是否保留有关Excel公式或自定义函数或宏的纸质笔记？

If you do, what kind of system do you have? Do you just scribble notes on bits of paper, and hope that you can find them later? Or do you have a fancy-ish? system for your Excel notes?

如果这样做，您将拥有哪种系统？ 您是否只是在纸上乱写笔记，并希望以后能找到它们？ 还是您有幻想的味道？ 您的Excel笔记的系统？

您是否保留电子记事本？ (Do You Keep Electronic Notes?)

If you don't keep paper notes, do you have some kind of electronic system instead?

如果您不保留纸质便笺，那么您是否拥有某种电子系统？

If you do, what program(s) do you use? Do you keep simple notes, or well-organized, carefully detailed notes?

如果这样做，您使用什么程序？ 您保留简单的笔记，还是组织良好，仔细详细的笔记？

Excel Notes在线吗？ (Are Your Excel Notes Online?)

Do you use a blog or forum posts to store your notes about Excel, and use Google (or something else) to search for them later?

您是否使用博客或论坛帖子来存储有关Excel的注释，并使用Google(或其他方式)在以后进行搜索？

In the olden days, I'd post things in Microsoft's Excel newsgroups (sigh), and could search for them in Deja-Vu (sigh 2).

在过去，我会将内容发布到Microsoft的Excel新闻组中(叹息)，然后可以在Deja-Vu中进行搜索(叹息2)。

Now, I use Google to search for my own blog posts, and other people's Excel posts or forum replies. Usually, I'm lucky, but it's not a foolproof system.

现在，我使用Google搜索自己的博客文章，以及其他人的Excel文章或论坛回复。 通常，我很幸运，但这不是万无一失的系统。

保罗·汉森的纸质Excel笔记本 (Paul Hanson's Paper Excel Notebooks)

Anyway, if you're a paper notes person, here are the Amazon links where you can get copies of Paul Hanson's paper Excel notebooks.

无论如何，如果您是纸质便笺的人，请在以下Amazon链接中获取Paul Hanson的纸质Excel笔记本的副本。

First, there's an Excel Power User Spreadsheet Notebook, in which you can store notes on your worksheet formulas and your VBA functions.

首先，有一个Excel Power User Spreadsheet Notebook ，您可以在其中存储有关工作表公式和VBA函数的注释。

There's also a simpler version, that's for storing notes about formulas only – The Spreadsheet Notebook.

还有一个更简单的版本， 仅用于存储有关公式的注释-Spreadsheet Notebook 。

翻译自: https://contexturesblog.com/archives/2020/01/30/keep-notes-on-excel-formulas-and-macros/

vba和宏