VBA插入随机日期 [英] VBA Insert random date

问题描述

你好;

我正在尝试写一个vba代码来插入一个特定时期之间的随机日期在excel（开始和结束范围）中的两个单元格中注明，并且仅给出工作日。我希望它只在同一个
行中的另一个单元格被更改时才在某个单元格中输入日期。当更改不同的行时，它不应该更改。非常感谢你。

I am trying to write a vba code to insert a random date that is between a certain period which is noted in two cells in excel (begin and end range) and giving only a workday. I want it to enter the date in a certain cell only when another cell on the same row is changed. And it should not change when a different row is changed. Thank you so much.

推荐答案

Re：VBA插入随机日期



同时发布在Excel for Developers论坛。

Re: VBA Insert random date

Also posted in Excel for Developers forum.

这篇关于VBA插入随机日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！