ShyButterfly
04-20-2018, 06:39 PM
Thank you for checking out my query :hi:
I’m developing a form, a visitor registry, and I’ve tried to find some way of calculating the expiry date of a card.
I have searched the web for something which I can adapt to my needs, however, that hasn’t been successful. I am still struggling to understand VBA and how to know in what modules I put what code, so if you could advise me where to put the code, I’d be mighty grateful: pray2:
I have uploaded a screenshot of the userform to give you the visual of what I am hoping to produce.
22071
The expiry date will be dependent on which combobox dropdown option (Card Type) is selected, based on a 3 column table (name range “TBL_Card_Type (B2:D7)” - image below), that has the value of days in the 3rd column.
The expiry date should not fall on a weekend or holiday. (I have a separate sheet of calendar with weekends and holidays that I’ll be referring to).
*Date Issued: TXT_StartDate
*Expiry Date: TXT_CARD_ExpiryDate
Dates to be in dd/mm/yyyy format please (currently having problems with date formatting changing when added to cells in the “Visitor Card Log Sheet” – goes to US format).
22072
Please advise if there is anything you need clarification on :beg:
Kind regards,
ShyButterfly
I’m developing a form, a visitor registry, and I’ve tried to find some way of calculating the expiry date of a card.
I have searched the web for something which I can adapt to my needs, however, that hasn’t been successful. I am still struggling to understand VBA and how to know in what modules I put what code, so if you could advise me where to put the code, I’d be mighty grateful: pray2:
I have uploaded a screenshot of the userform to give you the visual of what I am hoping to produce.
22071
The expiry date will be dependent on which combobox dropdown option (Card Type) is selected, based on a 3 column table (name range “TBL_Card_Type (B2:D7)” - image below), that has the value of days in the 3rd column.
The expiry date should not fall on a weekend or holiday. (I have a separate sheet of calendar with weekends and holidays that I’ll be referring to).
*Date Issued: TXT_StartDate
*Expiry Date: TXT_CARD_ExpiryDate
Dates to be in dd/mm/yyyy format please (currently having problems with date formatting changing when added to cells in the “Visitor Card Log Sheet” – goes to US format).
22072
Please advise if there is anything you need clarification on :beg:
Kind regards,
ShyButterfly