Excel 365 VBA programming by dr Peter J. Scharpff RI

Author:dr Peter J. Scharpff RI
Language: eng
Format: epub
Publisher: Bookboon.com Ltd.
Published: 2019-10-04T00:00:00+00:00

Add the code to close the form to the button cmdExecute.

Everything will work nicely now, but still a user can type anything he likes in a combobox. This may come in handy, for example when typing the first letter(s) to quickly select the day of your choice. But it also means that arbitrary input is possible, just try it. Changing the Style property will prevent that free input is entered.

Set the Style property to 2 - fmStyleDropDownList. To change the property of the control, it must be selected in the form.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.