Forms

[Matt]

I'm trying to fit a prompt into a macro, I have created a Form which asks for a monthly cost. I have linked the monthly cost to a particular cell. The cell is updated with the value that I enter but only when i manually close the form down, I cannot get the form to close down automaticallly. How can I put an "OK" to confirm on the form and then close the form or a cancel to close the form. Hope someone can help.

Thanks

Matt
This message was edited by Matt on 2002-02-18 07:33

 

[Juan Pablo González]

When do you want the form to close ? when you edit the textbox ? when you hit a button ?

 

[Matt]

Preferably when I hit an OK button

 

[Juan Pablo González]

Put a commandbutton there and this code will close the form when hit.

Private Sub CommandButton1_Click()
Unload Me
End Sub

 

[Matt]

Thanks Thats great!

 

[Art]

Matt- How did you link your form to cells in your spreadsheet?