[work] | Vba Wps

Have you tried VBA in WPS? What worked or failed? Share below 👇

Sub AutoFitAllColumns() Dim ws As Object Set ws = ActiveSheet ws.Columns.AutoFit End Sub vba 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 | Have you tried VBA in WPS

Sub HelloWPS() MsgBox "VBA works in WPS!" End Sub To run: . add this at the beginning:

If a macro runs slower in WPS, add this at the beginning: