How do I add an "Ok" button to a UserForm for Excel? 1

[navyguy]

Hi, I just discovered that I can create custom UserForms with the visual basic editor for excel. This is new to me.

It ought to be simple but I cant seem to figure it out. I want to be able to have an "Ok" button on the form so that it closes after items are selected in the form.

 

[Stretchwickster]

If you go into the Visual Basic Editor and click "UserForm" from the "Insert" menu, the userform appears as well as a control toolbox. The plain grey rectangle icon is the "Command Button". Simply click this once to select and click once more on your userform to drop it. (You may need to click the toolbox command button to deselect it)

Pressing F4 brings up the properties of the button. From here you can change its caption etc.

Double-click your command button and enter the required VBA code in there.

Hope this helps



Clive

 

[xlbo]

ps - the VBA code to make a form disappear is
formName.hide (controls keep their values)
or
formName.unload (controls lose their values) Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes