+ Reply to Thread
Results 1 to 3 of 3

Userform textbox if date equal Friday or Saturday

  1. 07-13-2021, 04:03 AM #1
    Undo
    Undo is offline
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Userform textbox if date equal Friday or Saturday

    Hey

    What the vba code for If the textbox date equal friday or saturday then msgbox?

    Thanks
    Reply With QuoteRegister To Reply
  2. 07-13-2021, 04:43 AM #2
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Userform textbox if date equal Friday or Saturday

    Type date in textbox day should appear on label after full date is typed.
    You should be able to work the rest out. 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
    Reply With QuoteRegister To Reply
  3. 07-13-2021, 09:59 AM #3
    Undo
    Undo is offline
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: Userform textbox if date equal Friday or Saturday

    Thank You!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date pattern help: Tuesday, Wednesday, Friday, Saturday
    By falcios in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-05-2020, 02:16 PM
  2. [SOLVED] Workday: date when we need to close the ticket and we have Friday and Saturday off
    By follow7771 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2020, 12:18 PM
  3. Find previous Saturday and next friday dates given a date
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-31-2016, 08:48 AM
  4. [SOLVED] Dates in Excel - If Saturday or Sunday, return Friday's date
    By gjrr4x1 in forum Excel General
    Replies: 6
    Last Post: 02-12-2015, 02:56 PM
  5. move date to next Monday if date is on a Friday, Saturday or Sunday
    By ea223 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2014, 01:54 PM
  6. [SOLVED] Return Friday before or equal to referenced date
    By wacky_diva in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2014, 11:24 PM
  7. Cell colour chg when formula results equal a weekend day, i.e., "Saturday" and a date that falls on a Saturday?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-19-2005, 08:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1