Hello,
I'm trying to setup a calendar control for an Excel spreadsheet. Unfortunately, our system is strict so it would be a headache to get an add-in installed. So, I was able to find instructions on using the Microsoft Date and Time Picker Control. It seems to work in that it will enter the selected date choose. However, it does not seem to be firing the Worksheet_Change event?
Anyone know why?
Last edited by ry94080; 05-10-2024 at 02:24 PM. Reason: Uploaded attachment
Guessing is time wasting - see big yellow banner - post your workbook for a definitive solution.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Hello i've uploaded the attachments. You'll notice when using the calendar control for the dates, the calculations in G12 - G17 do not work?
bump. anyone able to help?
I did not reply as I have not got DTPicker1 installed as it is no longer supported and in the past proven troublesome therefore I use my own creation.
In an instance such as this I would do the calcs in the code as on-sheet calculations sometimes do not respond to worksheet change events putting data into the sheet.
My approach would be as per the attached the data needs to be present for the worksheet event to trigger a result.
This is exactly what i needed! Thanks torachan!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks