You can do this using the Action Prompt for User Input and then following that with an If Then Action or a Switch Case Action which does something different depending if you press "OK" or "Cancel". Normally the Cancel Button would be checked to have "Cancel Macro" so, you need to uncheck that option to use the Cancel Button as a normal button. Harder to explain than just to show so, here is an example Macro: