+ Reply to Thread
Results 1 to 6 of 6

Option Box, Julian Date & Text Box Combination

  1. #1
    Registered User
    Join Date
    04-25-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2010
    Posts
    8

    Option Box, Julian Date & Text Box Combination

    Hi Guys,

    I'm hoping some of you can solve my problem by using your awesome macro skills.
    Problem:
    I would like to put data from user form where the data result (Purchase no.) is generates from purchase type, today's julian date (for julian date converter: http://www.longpelaexpertise.com/toolsJulian.php ) and series number-which typed manually.
    Herewith I attach the excel file along with detailed instruction for you to review.

    I really hope some of you guys can help solving my problem considering I'm still newbie in macros and need help from professionals like you all
    This macros will pretty much help me in my daily tasks.

    Thx.

    NB: Please check my files, you may change the text_box1 with any other tools which you find more efficient, to create result as I instructed.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Option Box, Julian Date & Text Box Combination

    Hello irsan anwar,

    In your instructions for the "Personal" and "Group" buttons on the UserForm, they is difference. I am assuming there should be a difference because you have have 2 buttons.

    From your Instructions...
    1. When “Personal “ option button clicked it will return value in text_box1 as <PR><space> <Julian date today>, in example shown as PR 15118, else is <PR><space> <Julian date today>
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    04-25-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2010
    Posts
    8
    Quote Originally Posted by Leith Ross View Post
    Hello irsan anwar,

    In your instructions for the "Personal" and "Group" buttons on the UserForm, they is difference. I am assuming there should be a difference because you have have 2 buttons.

    From your Instructions...
    Dear Leith Ross,

    You're right,the group option button should show GR Julian date when clicked,I just miss typo ☺

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Option Box, Julian Date & Text Box Combination

    Hello irsan anwar,

    Thanks for clearing that up. Don't feel bad about the typo. I have made more than I count.

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Option Box, Julian Date & Text Box Combination

    Hello irsan anwar,

    Here is the code for the Julian Date and UserForm. These have been added to the attached workbook.

    UserForm Code
    Please Login or Register  to view this content.
    Module1 - GetJulianDate
    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    04-25-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2010
    Posts
    8

    Re: Option Box, Julian Date & Text Box Combination

    Quote Originally Posted by Leith Ross View Post
    Hello irsan anwar,

    Here is the code for the Julian Date and UserForm. These have been added to the attached workbook.

    UserForm Code
    Please Login or Register  to view this content.
    Module1 - GetJulianDate
    Please Login or Register  to view this content.
    Dear Leith Ross,

    Thak you for your help. This is exactly what I expecting

+ 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. convert calendar date ddmmyy to julian date yyyydd
    By imichalopo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-13-2015, 01:47 AM
  2. Replies: 11
    Last Post: 06-21-2013, 03:25 AM
  3. [SOLVED] sumifs date and text combination
    By ktmjamal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2013, 12:12 AM
  4. to convert a julian date back to regular date
    By Lynn Hanna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-26-2006, 10:20 AM
  5. Convert a julian gregorian date code into a regular date
    By Robert in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2006, 02:10 PM

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