Set Default Values for TextBox in Excel VBA

preview_player
Показать описание
This video demonstrates how to set default values for TextBox controls using Excel VBA. This example also describes how to set the default value as today’s date and dates before and after today’s date.
Рекомендации по теме
Комментарии
Автор

Very interesting. I need to learn more about the codes.

ninastreet
Автор

A useful shortcut in Excel, especially if there is a lot of data to put in.

joe
Автор

Thanks. You can also format textbox3 to make the date appear in a different format... For example... FORMAT(DATE, "mmmm d, yyyy") with make date appear as January x, 2017.

krn