Have you tried VBA in WPS? What worked or failed? Share below 👇
Sub HelloWPS() MsgBox "VBA works in WPS!" End Sub To run: . vba wps
If a macro runs slower in WPS, add this at the beginning: Have you tried VBA in WPS
| Feature | MS Excel VBA | WPS VBA | |--------|-------------|---------| | Application.ScreenUpdating | Works | Works | | Application.Wait | Works | Works | | UserForm | Full support | Limited (some controls missing) | | ChartObject | Works | May need testing | | FileDialog | Works | Works | If a macro runs slower in WPS, add
Application.ScreenUpdating = False Application.Calculation = xlCalculationManual …and reset at the end.
Most people think VBA is exclusive to Microsoft Excel. But WPS Office (Spreadsheets & Writer) also supports VBA macros. However, there’s a catch — and a simple fix.
Getting Started with VBA in WPS Office: A Practical Guide