Results 1 to 20 of 27

Thread: UserForm to Return the MAX date in a TextBox resulting from VLOOKUP in ComboBox

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-21-2019, 02:45 AM #16
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    Do check out the help on DateAdd (https://docs.microsoft.com/en-us/off...teadd-function ) and note especially the order in which the arguments should appear and the data type of each argument.
    You may find it easier to just add 7 times what's in the other TextBox to MaxDate.
    2019-10-21_103954.jpg

    What is the name of this other TextBox?
    Last edited by p45cal; 10-21-2019 at 03:16 AM. Reason: spelling
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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