error message in basic is confusing ,when I assign value that has same name as existing function when i execute basic code in which assign value that has same name as existing function,like sub test1 year = 1 end sub I got error "アクションはサポートされていません。無効なプロシージャの呼び出し" which means invalid procedure call. I think this error message is confusing.its better that the message is like "try to assign value that has same name as existing function" Version: 7.1.1.2 (x64) / LibreOffice Community Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL
Message in english: Action not supported. Invalid procedure call. Message looks good to me, leaving unconfirmed.
Alain: what do you think? Is it possible to specify the error message like this?
Ideally, such a use should be detected at compile time. Instead a runtime error number 5 - Invalid procedure call - is returned; prepended with "Action not supported." text that isn't a documented error message. Indeed, One may expect some clearer message such as, but not limited to: 951 Unexpected symbol 'year' 958 Sub procedure or function procedure already defined 968 Symbol already defined differently 1004 Error executing a method I don't have a M$ environment to examine VBA behaviour at compile time and during runtime. Someone holding M*Office needs to confirm this report.
M$-Office shows a compiling error with "argument is not optional"