Forms created in Customized Ribbon Drop Down List

%3CLINGO-SUB%20id%3D%22lingo-sub-1185252%22%20slang%3D%22en-US%22%3EForms%20created%20in%20Customized%20Ribbon%20Drop%20Down%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1185252%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20question%20is%20regarding%20creating%20a%20form%20in%20Customize%20the%20Ribbon%20that%20are%20created%20via%20a%20Table.%26nbsp%3B%20I%20have%20a%20table%20that%20I%20would%20like%20the%20user%20to%20be%20able%20to%20input%20the%20data%20via%20a%20form%20and%20populate%20that%20information%20into%20a%20table.%26nbsp%3B%20I%20know%20how%20to%20do%20this%20in%20general%2C%20however%2C%20is%20there%20a%20way%20to%20have%20the%20form%20that%20Excel%20creates%20to%20have%20a%20drop%20down%20list%3F%26nbsp%3B%20For%20example%2C%20I%20would%20like%20the%20form%20to%20allow%20input%20of%2C%20a%20customer%20name%2C%20description%2C%20etc%2C%20and%20also%20to%20utilize%20a%20drop%20down%20list%20for%20the%20status%20of%20data%20(Open%2C%20Closed)%2C%20the%20Requestor%20(name%20from%20a%20list%20of%20employees).%26nbsp%3B%20I%20know%20I%20can%20set%20a%20data%20validation%20in%20the%20cells%20individually%2C%20however%2C%20I%20am%20trying%20to%20have%20this%20information%20within%20the%20form%20itself.%26nbsp%3B%20I%20know%20that%20I%20can%20create%20this%20information%20within%20Virtual%20Basic%20part%20of%20Excel%2C%20however%2C%20I%20am%20not%20that%20familiar%20with%20this%20in%20Excel%20yet.%26nbsp%3B%20If%20anyone%20can%20assist%20with%20an%20answer%2C%20even%20if%20this%20cannot%20be%20performed%2C%20I%20would%20greatly%20appreciate%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1185252%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Contributor

My question is regarding creating a form in Customize the Ribbon that are created via a Table.  I have a table that I would like the user to be able to input the data via a form and populate that information into a table.  I know how to do this in general, however, is there a way to have the form that Excel creates to have a drop down list?  For example, I would like the form to allow input of, a customer name, description, etc, and also to utilize a drop down list for the status of data (Open, Closed), the Requestor (name from a list of employees).  I know I can set a data validation in the cells individually, however, I am trying to have this information within the form itself.  I know that I can create this information within Virtual Basic part of Excel, however, I am not that familiar with this in Excel yet.  If anyone can assist with an answer, even if this cannot be performed, I would greatly appreciate it.

0 Replies