+ Reply to Thread
Results 1 to 14 of 14

need help vlookup text box and date picker

Hybrid View

mazan2010 need help vlookup text box... 12-25-2016, 11:03 AM
sorensjp Re: edit userform from date... 12-25-2016, 07:36 PM
mazan2010 Re: need help vlookup text... 12-26-2016, 01:17 PM
mazan2010 Re: need help vlookup text... 12-28-2016, 10:48 AM
bakerman2 Re: need help vlookup text... 12-29-2016, 04:03 AM
mazan2010 Re: need help vlookup text... 12-29-2016, 04:05 AM
kasan Re: need help vlookup text... 12-29-2016, 04:19 AM
mazan2010 Re: need help vlookup text... 12-29-2016, 05:04 AM
kasan Re: need help vlookup text... 12-29-2016, 05:24 AM
mazan2010 Re: need help vlookup text... 01-04-2017, 02:41 AM
kasan Re: need help vlookup text... 01-04-2017, 03:42 AM
mazan2010 Re: need help vlookup text... 01-04-2017, 08:14 AM
kasan Re: need help vlookup text... 01-04-2017, 08:23 AM
mazan2010 Re: need help vlookup text... 01-04-2017, 11:43 AM
  1. #1
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: need help vlookup text box and date picker

    Hi,
    Not sure how excatly you want to add date from DTpicker. Change code for DTpicker to this one and picked date will appear in firs empty cell.
    Private Sub DTPicker1_Change()
        Dim lRow As Long
        lRow = Sheets("StockDatabase").Cells(Sheets("StockDatabase").Rows.Count, "C").End(xlUp).Row + 1
        Sheets("StockDatabase").Cells(lRow, 3).Value = DTPicker1.Value
    End Sub

  2. #2
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: need help vlookup text box and date picker

    i try but its not working
    can try in my attached file

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date picker used to populate text box. Date changes back to original value on opening.
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2016, 09:42 AM
  2. Interactive userform with date picker as control source to pull data
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2015, 05:40 PM
  3. [SOLVED] Add date to table using date picker in a userform
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-28-2015, 09:25 PM
  4. [SOLVED] Date Time Picker Change to Text
    By juriemagic in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-23-2014, 08:49 AM
  5. vetting of my code, and edit date picker on my form
    By omolemo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2013, 10:02 AM
  6. Date Picker won't select current date: Userform
    By valkok in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2011, 06:09 PM
  7. [SOLVED] Format text box and move across date time picker
    By Basil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2005, 05:05 PM

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