So, the Vegetarian check box is greyed-out until required. However, if the person making the booking does not want lunch we do not need to know whether or not they are vegetarian. There are two check boxes ( Lunch Required and Vegetarian) that, because they are not grouped in a frame, can both be chosen if required. There are three option buttons ( Introduction, Intermediate and Advanced) grouped in a frame ( Level) so that the user can choose only one of the options. There are two simple text boxes ( Name: and Phone:) into which the user can type free text, and two combo boxes ( Department and Course) that let the user to pick an item from the list. When the user clicks the OK button their input is entered into the next available row on the worksheet. ![]() It uses a selection of controls including text boxes, combo boxes, option buttons grouped in a frame, check boxes and command buttons. The Course Booking Form is a simple form illustrating the principles of UserForm design and the associated VBA coding.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |