+ Reply to Thread
Results 1 to 4 of 4

How Can I Add/Subtract One Day from Hijri Calendar Using VBA

  1. #1
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Question How Can I Add/Subtract One Day from Hijri Calendar Using VBA

    Hello,

    I can Adjust Hijri Calendar (Add/Subtract one or two days) in Window by Changing the registry key using the following VBA Code

    Please Login or Register  to view this content.
    But this doesn't affects Hijri Dates in Excel.

    How Can I Adjust The Hijri Calendar days in Excel using VBA?

    Hint:
    About : AddHijriDate Using Registry key modificaition
    https://learn.microsoft.com/en-us/wi...s/addhijridate

    I Found this article about Hijri Date Adjustment
    https://learn.microsoft.com/en-us/do...ijriadjustment

    How Can apply this / or something like this using excel vba?
    Last edited by exceere; 07-19-2023 at 02:25 AM.

  2. #2
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: How Can I Add/Subtract One Day from Hijri Calendar Using VBA

    No Answer?!

    Is My Case is Very Complicated?

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,375

    Re: How Can I Add/Subtract One Day from Hijri Calendar Using VBA

    Administrative Note:

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: How Can I Add/Subtract One Day from Hijri Calendar Using VBA

    I'm Waiting for an expert to this very complicated issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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