Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a form based on a list using vba in excel
I have a user that does not have any excel skills. They are continuously
ruining a sheet that has formulas in it, and enter data using the wrong format, don't delete unused rows, etc. I thought I could make the sheet a list, and force them to use the form function to enter and delete data. How do I recognize when someone closes the form as an event so that I can trigger additional vba programming. Does anyone know how to make this work? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a form based on a list using vba in excel
You would launch the form from VBA using a statement like
Userform1.Show and would then control would not be passed back to that macro until the form was closed. So you know by default. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "maidrite" wrote in message ... I have a user that does not have any excel skills. They are continuously ruining a sheet that has formulas in it, and enter data using the wrong format, don't delete unused rows, etc. I thought I could make the sheet a list, and force them to use the form function to enter and delete data. How do I recognize when someone closes the form as an event so that I can trigger additional vba programming. Does anyone know how to make this work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a data list by using a form | Excel Worksheet Functions | |||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL | Excel Worksheet Functions | |||
Create database based on excel form | Excel Discussion (Misc queries) | |||
How do you create a list with name address phone in a column form. | Excel Discussion (Misc queries) | |||
Create drop list on form from range names? | Excel Programming |