{"id":12074,"date":"2011-10-15T19:01:22","date_gmt":"2011-10-15T19:01:22","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=110"},"modified":"2011-10-15T19:01:22","modified_gmt":"2011-10-15T19:01:22","slug":"different-settings-of-controls-in-excel-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/10\/different-settings-of-controls-in-excel-macro\/","title":{"rendered":"Different Settings of Controls in Excel Macro"},"content":{"rendered":"

When we re-size the cell size in Excel, my controls like buttons, text boxes etc. also get moved and re-sized. In this post we will see how can change the setting to get rid of this issue.
\n<\/p>\n

1. Go to Developer Tab of the Excel Sheet where your control exists.
\n2. Now click on \u201cDesign Mode\u201d button in the Control section.<\/p>\n

\"\"<\/p>\n

3. Right click on that particular control
\n4. Select \u201cFormat Control\u201d
\n5. In the format Control settings dialog box, go to \u201cProperties\u201d Tab.<\/p>\n

\"\"<\/p>\n

6. Here we have 3 option, select any one of them as per your requirement:<\/p>\n