How to update popup (drop down) cells in Numbers using Applescript

Hello

I just noticed the script may occasionally fail due to timing issue of GUI scripting. It will be safer to add a small delay in _delete() handler inside set_popup_items_from_range() handler such as -

        on _delete()
            (*
                virtual key code:
                    kVK_Delete    = 0x33    (51)
            *)
            tell application "Numbers" to activate
            tell application "System Events"
                tell process "Numbers"
                    key code 51 -- delete
                end tell
            end tell
            delay 0.2 -- # adjust as needed
        end _delete

Regards,

H

You're quite welcome! Glad to know it helped. 😉

Best regards from Japan,

Hiroto