Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating drop down menus in a data form
I'm generally an Access person, but have an excel task to
complete. I need to create a form within excel 97 that can populate fields with drop down lists. I've written a macro to auto-start the data-form that comes with excel 97 but am not sure if it is possible to add drop downs to it. I wonder if I will need to create a completely new form. Thanks in advance for any input/ideas/links ! My deadline is nearing. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating drop down menus in a data form
Instead of creating your own form, you might be able to use John
Walkenbach's Enhanced Data Form. http://j-walk.com/ss/dataform/index.htm It allows comboboxes, and unlimited fields. harrys wrote: I'm generally an Access person, but have an excel task to complete. I need to create a form within excel 97 that can populate fields with drop down lists. I've written a macro to auto-start the data-form that comes with excel 97 but am not sure if it is possible to add drop downs to it. I wonder if I will need to create a completely new form. Thanks in advance for any input/ideas/links ! My deadline is nearing. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating drop down menus in a data form
Hi Debra -
Your suggestion was perfect. I even purchased the VBA password after creating the drop downs from JWalk Enhanced Data Form. My sincere thanks for your timely solution. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
creating drop down menus | Excel Discussion (Misc queries) | |||
Drop-Down Menus in Data Entry Form? | Excel Discussion (Misc queries) | |||
Creating Buttons to navigate and drop down menus | New Users to Excel | |||
Creating Drop down menus in an excel cell | Excel Worksheet Functions |