Forms

Matt · Feb 18th, 2002, 08:30 AM

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 · Feb 18th, 2002, 09:10 AM

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

Matt · Feb 18th, 2002, 09:12 AM

Preferably when I hit an OK button

Juan Pablo González · Feb 18th, 2002, 09:18 AM

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

Private Sub CommandButton1_Click()
Unload Me
End Sub

Matt · Feb 18th, 2002, 09:20 AM

Thanks Thats great!

Art · Feb 19th, 2002, 06:50 PM

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

Feb 18th, 2002, 09:10 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	When do you want the form to close ? when you edit the textbox ? when you hit a button ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Feb 18th, 2002, 09:18 AM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Put a commandbutton there and this code will close the form when hit. Private Sub CommandButton1_Click() Unload Me End Sub __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 08:30 AM	#1
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	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 ]

Feb 18th, 2002, 09:12 AM	#3
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Preferably when I hit an OK button

Feb 18th, 2002, 09:20 AM	#5
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Thanks Thats great!

Feb 19th, 2002, 06:50 PM	#6
Art New Member Join Date: Feb 2002 Location: Kansas City, MO Posts: 1	Matt- How did you link your form to cells in your spreadsheet?