Excel Dialogs using PyXLL CTP functions
I built a couple custom dialogs using PyXLL Custom Task Panes (CTPs) — these dialogs require no worksheet reference!
PyXLL v5.x is required to use the CTP functions.
Dialog Screenshots
Generic Dialog
AISC Dialog with to-scale cross section drawing
Dialogs in Action — Video
In the video, notice that the to-scale cross section drawing is updated as each AISC shape is selected.
https://www.mathpax.com/feed 
