name of day and if function

**newegyptian** · 04-07-2019, 12:11 PM

I want to creat text box

If date = saturday , vacancy
If date = sunday , work
If date = monday , surgery

And so on

How i can make that

**June7** · 04-07-2019, 01:18 PM

Write a custom VBA function.

**Missinglinq** · 04-07-2019, 05:21 PM

Your info on exactly what you're trying to do is sparse...but the general approach would be to use the WeekDay() function. If you're basing this on an entered date...the syntax would be

Code:

If WeekDay(Me.DateEntered) = 1 Then Me.YourTextboxName = "Work" 'Sunday If WeekDay(Me.DateEntered) = 2 Then Me.YourTextboxName = "Surgery" 'Monday ........... ............ ............. If WeekDay(Me.DateEntered) = 7 Then Me.YourTextboxName = "Vacancy" 'Saturday

If basing it on the Current Date

Code:

If WeekDay(Date()) = 1 Then Me.YourTextboxName = "Work"

And so forth.

You could also probably use the Select Case construct instead of If...Then.

Linq ;0)>

**newegyptian** · 04-07-2019, 07:04 PM

Originally Posted by Missinglinq

Your info on exactly what you're trying to do is sparse...but the general approach would be to use the WeekDay() function. If you're basing this on an entered date...the syntax would be

Code:

If WeekDay(Me.DateEntered) = 1 Then Me.YourTextboxName = "Work" 'Sunday If WeekDay(Me.DateEntered) = 2 Then Me.YourTextboxName = "Surgery" 'Monday ........... ............ ............. If WeekDay(Me.DateEntered) = 7 Then Me.YourTextboxName = "Vacancy" 'Saturday

If basing it on the Current Date

Code:

If WeekDay(Date()) = 1 Then Me.YourTextboxName = "Work"

And so forth.

You could also probably use the Select Case construct instead of If...Then.

Linq ;0)>

THANKS ALOT
REALLY YOU HELPED ME
MANY THANKS
SOLVED

name of day and if function

Thread Tools

name of day and if function

Similar Threads

Convert Private Function to Public Function

IIf Function returns blank Cell if Like function is not met

Function required for access similar to sumif function of excel

Help with building a function to accept more that one parameter into a function.

Function to load reference library - Not seeing something in function

Posting Permissions