Timeline for Is it really time?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 16, 2020 at 12:31 | comment | added | Taylor Raine |
If you use our tips and some tricks, like removing whitespace, using integer division, abbreviate the print statement, use Right("000000"&i,6) and use the mid function instead of the left and right calls for calculating m, you can get your solution way down in size. With vanilla VBA, you can get down to 85 bytes w/ Sub a(i):v=Right("000000"&i,6):Debug.?v\1E4<24*(Mid(v,3,2)<60)*(v Mod 100<60):End Sub and if you use an Excel VBA immediate window function you can get down to 65 as v=Right("000000"&[A1],6):?v\1E4<24*(Mid(v,3,2)<60)*(v Mod 100<60)
|
|
| Mar 16, 2020 at 12:27 | comment | added | Taylor Raine | As it stands, unfortunately, your response is not quite valids, as it does not properly take input (see rules above), but it is functionally correct. | |
| Mar 16, 2020 at 12:26 | comment | added | Taylor Raine | Hi there and Welcome to PPCG! I recommend that you take a look at our Tips for Golfing in VBA for some hints on how to get your code even shorter, and for some general rules on input and out as they relate to VBA (VBA is weird to the rules are weird) | |
| Mar 2, 2020 at 22:18 | history | edited | Marx | CC BY-SA 4.0 |
added 45 characters in body
|
| Mar 2, 2020 at 21:39 | comment | added | Marx | It does have function declaration, yeah. I'll edit my answer to follow the rules. Thank you! | |
| Mar 2, 2020 at 10:58 | comment | added | Neil |
You can replace the If and Do Until with Do While which will check the condition before the loop even starts. I don't specifically know VBA but does it not have some sort of function declaration? Normally answers are required to be either functions or full programs that include I/O (Input, Print etc.)
|
|
| Feb 27, 2020 at 5:45 | history | edited | Marx | CC BY-SA 4.0 |
added 10 characters in body
|
| Feb 27, 2020 at 0:30 | review | First posts | |||
| Feb 27, 2020 at 0:56 | |||||
| Feb 27, 2020 at 0:29 | history | answered | Marx | CC BY-SA 4.0 |