Design Mode in VBA

[michaeldh]

Guy's,

I was wondering what design mode is used for in VBA. I always have this switched off when writing programs. What does it do and when should you activate this feature?

Cheers.

 

[parry]

Hi, design mode is used to edit a control on a sheet. For example, if you put a list box on a sheet and you later wanted to resize the box, then you would select design mode so you can do that. In non-design mode the control is effectively locked in place.

If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.

Hope Ive explained this well enough.

 

[Barry Katcher]

Thanks, Parry, I've been wondering about that myself.

 

[Fred Evans]

thanks this helped me to
fred evans

 

[thenaturalprogrammer]

Guy's,

I was wondering what design mode is used for in VBA. I always have this switched off when writing programs. What does it do and when should you activate this feature?

Cheers.

Almost 14 years after this question was posted, I was looking for the answer, but didn't see any clear, straight answer on the internet, though a link from MS may be helpful (https://msdn.microsoft.com/en-us/library/aa716232(v=vs.60).aspx).

Testing with my applications, the VBA design mode button appears to ...
...in Excel, close all open forms.
...in Access, put all open forms into design mode, which helps you not to get interrupted by some timer while trying to make changes to the code.