locked
regarding change the calendar type in userform excel vba RRS feed

  • Question

  • good greeting my dears

    how can change the type of the calendar in userform excel vba from jeorgian date (2018)

    to hijrian date (1439) 

    thanks.............

    Saturday, February 24, 2018 5:31 PM

Answers

  • Hi TAREK,

    >> how can change the type of the calendar in userform excel vba from jeorgian date (2018) to hijrian date (1439)

    It is impossible. Calendar Control in Excel does not support hijri date.

    Best Regards,

    Tao Zhou


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by TAREK SHARAF Monday, February 26, 2018 10:49 AM
    Monday, February 26, 2018 7:05 AM
  • Hi TAREK,

    For built-in Excel control, it is impossible.

    You may try to develop your own COM Control and use it in Excel, but in my option, it is not worth to do that.

    Best Regards,

    Tao Zhou


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by TAREK SHARAF Tuesday, February 27, 2018 4:46 AM
    Tuesday, February 27, 2018 2:42 AM

All replies

  • good greeting my dears

    how can change the type of the calendar in userform excel vba from jeorgian date (2018)

    to hijrian date (1439) 

    thanks.............

    Monday, February 26, 2018 5:37 AM
  • Hi TAREK,

    >> how can change the type of the calendar in userform excel vba from jeorgian date (2018) to hijrian date (1439)

    It is impossible. Calendar Control in Excel does not support hijri date.

    Best Regards,

    Tao Zhou


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by TAREK SHARAF Monday, February 26, 2018 10:49 AM
    Monday, February 26, 2018 7:05 AM
  • dear tao

    is there any solution for this problem

    regards.......

    Monday, February 26, 2018 10:49 AM
  • Hi TAREK,

    For built-in Excel control, it is impossible.

    You may try to develop your own COM Control and use it in Excel, but in my option, it is not worth to do that.

    Best Regards,

    Tao Zhou


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by TAREK SHARAF Tuesday, February 27, 2018 4:46 AM
    Tuesday, February 27, 2018 2:42 AM