Timeline for How to make this macro work with a date? [closed]
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 10 at 13:28 | history | closed |
DrMoishe Pippik cybernetic.nomad Toto music2myear Joep van Steen |
Needs details or clarity | |
| Jul 6 at 10:10 | answer | added | DjC | timeline score: 1 | |
| Jul 5 at 0:52 | comment | added | Craig | Do you know how to debug your macro? You are going to need to determine exactly what the value is that's coming from the field where you enter the filter date value. Ultimately, Excel's dates are stored as numbers (and it's just the formatting that displays them in a friendly date format) - but if the field where you enter the date is formatted as "Text", or formatted in some other way that's not actually putting the underlying number value in the cell that Excel expects, then your comparison is not going to be working properly | |
| Jul 4 at 16:31 | review | Close votes | |||
| Jul 10 at 13:28 | |||||
| Jul 4 at 16:16 | comment | added | DrMoishe Pippik | "I've got a column set to short date format of dd/mm/yy but whenever I type anything it just hides all rows." What does that mean? Where and what are you typing? | |
| Jul 4 at 15:45 | comment | added | CommunityBot | Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. | |
| Jul 4 at 15:44 | history | edited | Matt Murphy | CC BY-SA 4.0 |
added 107 characters in body
|
| S Jul 4 at 15:43 | review | First questions | |||
| Jul 4 at 15:45 | |||||
| S Jul 4 at 15:43 | history | asked | Matt Murphy | CC BY-SA 4.0 |