Forum Discussion
Why does my Userform freeze when ShowModal is False?
I am new to Modal and Modeless Userforms. I am trying to build a simple Userform as a proof of concept that you can change the contents of cells on a sheet and still run your Userform. My goal is to ...
Riley_Johnson RefEdit Controls have always been notoriously glitchy. One thing's for sure, they cannot be used on modeless forms (must be modal). This is well documented online, on various forums and blogs. Here's two such examples:
- https://stackoverflow.com/questions/49543651/vba-using-refedit...
- https://peltiertech.com/using-refedit-controls-in-excel-dialogs/
Also, I recommend ditching the cmdSwapCells_Enter routine, as it's causing the form to crash. Just use the Click event for the command button. See attached...