Forum Discussion
why doesn't markros start in vba excel?
why doesn't markros start in vba excel?
This statement:
Public Const activate_end As Date = "08.02.2023"
causes a compile error as you are trying to assign a string to a date variable.The correct syntax is:
Public Const activate_end As Date = #2/8/2023#
Public Const activate_end As Date = "08.02.2023"
causes a compile error as you are trying to assign a string to a date variable.The correct syntax is:
Public Const activate_end As Date = #2/8/2023#
- Check Tools, References. Are there any checked references marked as "MISSING" ?
The code is currently paused (see the line highlighted in yellow), so Tools > References is disabled.
You have to stop the code, then you'll be able to select Tools > References...
