Results 1 to 18 of 18

VBA USERFORM - Input date in textbox and comments in another textbox

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    218

    VBA USERFORM - Input date in textbox and comments in another textbox

    Hello,

    In my form on the submit click code, I want the user to be able to enter the date in the textbox for the corresponding cells, then comments in their corresponding cells.

    I was not able to upload the form or code to go with it due to size limits, so I have attached them both. Any assistance is appreciated If anyone has a better way then a textbox for dates, I am all ears.

    Code for Date that is now working
    'If Me.CS1.Value Then .Range("D11").dsDate = DateSerial("01/01/2020")
    Code for textbox comments is not working
            If Me.T1.Value Then .Range("D12").Value = T1.Value
            If Me.T2.Value Then .Range("F12").Value = T2.Value
            If Me.T3.Value Then .Range("H12").Value = T3.Value
            If Me.T4.Value Then .Range("J12").Value = T4.Value
            If Me.T5.Value Then .Range("L12").Value = T5.Value

    form.PNG

    Excel.PNG
    Attached Files Attached Files
    Last edited by Shruder; 04-07-2023 at 04:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform, fill Textbox with calender week (ww) depending on date from another TextBox
    By crowmagnus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2020, 09:24 AM
  2. Userform textbox date input problem
    By GraingerT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2019, 09:15 AM
  3. Userform textbox to combine all cells comments
    By mariec_06 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-05-2016, 10:53 AM
  4. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  5. [SOLVED] Unable to match Textbox comments in a Userform
    By Ortz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2014, 03:23 PM
  6. input the value of a Combobox and a textbox to a TEXTBOX directly from a userform
    By Gordonhk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 03:25 PM
  7. Use textbox input and VLookup to update another textbox on same userform
    By gcoug in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2011, 10:39 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1