The value of 236.25 is what is needed to display everything on the form and this number will be used later in the tutorial. For now, make the form large enough to display all of the contents on it then, look to the properties window and take note of the number for the Height property:.Alt+F11 to go to the VBA window > Double-click the UserForm from the Project window (Ctrl+R if you don't see that window) and then make sure the form itself is selected and not a control within the form do this by clicking the title bar at the top of the form.Īlso, make sure the properties window is displayed, if it isn't, hit F4 to display it. This allows you to put scroll bars onto a form so that it can hold information that is accesible when the user scrolls down or to the right.
0 Comments
Leave a Reply. |