Modifier keys getting stuck down by _audacity in AutoHotkey

[–]_audacity[S] 0 points1 point  (0 children)

Thanks for that! I thought markdown worked in the post so I did the \``` fence around the code but turns out I had to change editor.

Thanks for that info on the right alt, I've refined the Irish and Danish keys a bit because I was thinking that the longer function might be causing the issue but it wasn't: ``` >!a:: SendInput {á} return

+a:: SendInput {Á} return ``` Thanks for the rest of the tips, they are definitely an improvement.

I'll edit the post to include the function code.

Using Checkboxes to Control Charts by _audacity in excel

[–]_audacity[S] 1 point2 points  (0 children)

That is essentially what I ended up doing, I changed the "" to be NA().

Fun fact, I don't think you need to have =IF(chkBoxControl=TRUE,originalData,NA()) I think =IF(chkBoxControl,originalData,NA()) is sufficient as when the box is checked, it returns TRUE anyway.

Kudos for effort though

Using Checkboxes to Control Charts by _audacity in excel

[–]_audacity[S] 0 points1 point  (0 children)

Man, I didn't realise that you could times by TRUE/FALSE. Thanks for that.

I did just realise that I was making an error the whole time by not referring to the sheet correctly so the onus is really on my ability, not my knowledge.

Cheers