+ Reply to Thread
Results 1 to 4 of 4

Reference last Userform Taskbok

  1. #1
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Reference last Userform Taskbok

    I am trying the following code but it is referencing not the last but the one befor that. I have a calander on a userform along with sereval textboxes. I want to clik on the textbox and then click the calander to fill in the daye to that checkbox.

    Right now this code is doing the one before. For example, if I click ib textbox2 and then texbox3 and then click the calander it is putting the date in textbox2.


    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Reference last Userform Taskbok

    Shouldn't you use the Enter event of the textboxes rather than the Exit?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Re: Reference last Userform Taskbok

    Do I just replace Exit with Enter

  4. #4
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Re: Reference last Userform Taskbok

    Awww.. my code works, its because the textboxes are in a frame. Now I have to figure out how that fix that

+ 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. [SOLVED] Is it possible to use textbox value from userform as a Row or Column Reference
    By Excel_Runner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2014, 03:23 AM
  2. UserForm Name reference question.
    By JieJenn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2012, 05:14 AM
  3. Userform Sub Reference Failure
    By Ziilch in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-28-2009, 01:38 PM
  4. Cell reference to userform
    By Jens Peter Nielsen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2005, 07:05 PM
  5. Reference a cell in a worksheet from a userform
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2005, 04:06 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