Timeline for Tips for golfing in VBA

8 events

when toggle format	what		by	license	comment
Jun 17, 2020 at 9:04	history	edited	CommunityBot		Commonmark migration
Aug 12, 2017 at 16:43	comment	added	Greedo		In fact, here is a list of colours with their mathematical representations, which are shorter than either the positive or negative decimal versions: `&000080: 2^7, &000100: 2^8, &000200: 2^9, &000400: 2^10, &000800: 2^11, &001000: 2^12, &002000: 2^13, &004000: 2^14, &008000: 2^15, &010000: 2^16, &01FFFF: 2^17-1, &020000: 2^17, &03FFFF: 2^18-1, &040000: 2^18, &07FFFF: 2^19-1, &080000: 2^19, &0FFFFF: 2^20-1, &100000: 2^20, &1FFFFF: 2^21-1, &3FFFFF: 2^22-1, &400000: 2^22, &7FFFFF: 2^23-1` n.b. not necessarily complete, but I think I did a fairly thorough job
Aug 12, 2017 at 16:42	comment	added	Greedo		Good to know what was going on there, I just discovered it by accident in that question - but this clear explanation shows exactly how it works. Another thing to bear in mind is that certain key colours can be reduced with mathematical operators; `rgbWhite`=`2^24-1` although could possibly be reduced further if you miss off the -1 to get roughly there
Aug 11, 2017 at 11:57	history	edited	Taylor Raine	CC BY-SA 3.0	deleted 1 character in body
Aug 8, 2017 at 16:37	history	edited	Taylor Raine	CC BY-SA 3.0	added 54 characters in body
Aug 7, 2017 at 21:50	history	edited	Taylor Raine	CC BY-SA 3.0	added 4 characters in body
Aug 6, 2017 at 11:59	history	edited	Taylor Raine	CC BY-SA 3.0	added 3 characters in body
Aug 3, 2017 at 12:22	history	answered	Taylor Raine	CC BY-SA 3.0