I have an excel form that I enter a date and after tabbing to the next field I would like a label to show the day of the week. I am able to create a label to the right of the date field but cannot figure out where or how to put the LabelClosingDay = Weekday(TextBoxClosingDate) so that it calculates the day after tabbing from the date field.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Day of week in an excel form
- Thread starter mecerrato
- Start date
My Aswer Is This
Well-known Member
- Joined
- Jul 5, 2014
- Messages
- 19,511
- Office Version
- 2021
- Platform
- Windows
We could add a combobox where when the userform is opened dates are automatically entered into the combobox. Then you could choose a date in the combobox and then the date you choose would be entered where you wanted. Would this work for you?
Upvote
0
Excel Facts
Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
