+ Reply to Thread
Results 1 to 9 of 9

Userform Problem

  1. 04-02-2014, 10:39 PM #1
    yashagarwal
    yashagarwal is offline
    Registered User
    Join Date
    03-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    46

    Userform Problem

    I have a userform for employee login.
    This userform has date as well as time.
    on clicking the login button, the date, time and the other details get copied to a sheet on my workbook.
    My date is in "dd-mm-yyyy" format in the form.

    But the problem is that when it gets copied, it gets changed. Example today is 3-April-14, but it gets copied as 4-march-2014.....
    check the workbook for the problem,.......please help me to solve this issue.
    thanks
    Attached Files Attached Files
    Last edited by yashagarwal; 04-03-2014 at 01:32 AM. Reason: Attaching the files
    Reply With QuoteRegister To Reply
  2. 04-02-2014, 10:50 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Userform Problem

    Picture:

    Hi and welcome to the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 04-02-2014, 11:12 PM #3
    yashagarwal
    yashagarwal is offline
    Registered User
    Join Date
    03-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Userform Problem

    Quote Originally Posted by alansidman View Post
    Picture:

    Hi and welcome to the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Okay......ill make the sample workbook and upload in sometime

    Thanks for immediate response
    Reply With QuoteRegister To Reply
  4. 04-03-2014, 01:33 AM #4
    yashagarwal
    yashagarwal is offline
    Registered User
    Join Date
    03-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Userform Problem

    Quote Originally Posted by alansidman View Post
    Picture:

    Hi and welcome to the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

    I have uploaded the file! :D
    Reply With QuoteRegister To Reply
  5. 04-03-2014, 01:49 AM #5
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Userform Problem

    try this
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-
    Reply With QuoteRegister To Reply
  6. 04-03-2014, 01:56 AM #6
    yashagarwal
    yashagarwal is offline
    Registered User
    Join Date
    03-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Userform Problem

    Quote Originally Posted by john55 View Post
    try this
    Please Login or Register  to view this content.
    Tried this.....still says 04-03-2014 instead of 03-04-2014
    Reply With QuoteRegister To Reply
  7. 04-03-2014, 01:59 AM #7
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Userform Problem

    hi
    please change it to 
    Please Login or Register  to view this content.
    it shows me 3-apr-...
    Reply With QuoteRegister To Reply
  8. 04-03-2014, 02:03 AM #8
    yashagarwal
    yashagarwal is offline
    Registered User
    Join Date
    03-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Userform Problem

    It shows Apr now.....
    Thanks

    Is there no way to make it show the number and not April?
    Else this will do
    Reply With QuoteRegister To Reply
  9. 04-03-2014, 08:42 AM #9
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Userform Problem

    you're welcome!
    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. [SOLVED] Userform called from another userform textbox - unload problem
    By barryleajo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-27-2013, 01:09 PM
  2. userform problem
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2006, 04:57 PM
  3. UserForm problem
    By Daminc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2006, 09:57 AM
  4. userform problem
    By Pierre via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2005, 11:05 AM
  5. Userform from a Userform Problem
    By Adrian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2005, 12: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1