| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addding a combobox to a workbook?
Hello,
I've built some VBA code that builds a seperate workbook for each agency to show their data. However, I want to add a dropdown field in column K in which the user can select a reason code from a list. This list of reason codes should be in a seperate worksheet called "reason codes" Can this be down with validation? Thanks Brian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Addding a combobox to a workbook?
Sure. Try this:
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "BerkshireGuy" wrote in message oups.com... Hello, I've built some VBA code that builds a seperate workbook for each agency to show their data. However, I want to add a dropdown field in column K in which the user can select a reason code from a list. This list of reason codes should be in a seperate worksheet called "reason codes" Can this be down with validation? Thanks Brian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Addding a combobox to a workbook?
Validation is absolutely correct. My recommendaion is to create a named range
(call it something novel like ReasonCodes) on your Reason Codes sheet. Now select Data - Validation - List In the List box add =ReasonCodes That should do it... -- HTH... Jim Thomlinson "BerkshireGuy" wrote: Hello, I've built some VBA code that builds a seperate workbook for each agency to show their data. However, I want to add a dropdown field in column K in which the user can select a reason code from a list. This list of reason codes should be in a seperate worksheet called "reason codes" Can this be down with validation? Thanks Brian |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Addding a combobox to a workbook?
Hi BerkshireGuy,
If the validation list is in a different worksheet, give the list a name and use the name in the data validation's source box. --- Regards, Norman "BerkshireGuy" wrote in message oups.com... Hello, I've built some VBA code that builds a seperate workbook for each agency to show their data. However, I want to add a dropdown field in column K in which the user can select a reason code from a list. This list of reason codes should be in a seperate worksheet called "reason codes" Can this be down with validation? Thanks Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP PLEASE..Inserting combobox (ActiveX control) makes workbook c | Excel Discussion (Misc queries) | |||
| Addding a Random number to a fixed number..... | Excel Discussion (Misc queries) | |||
| How to Set VB ComboBox ListFillRange to a Defined Range in an external workbook | Excel Programming | |||
| filling a combobox (without being prompted to save the workbook EVERY time its opened | Excel Programming | |||
| Referencing a ComboBox control from a Workbook Object? | Excel Programming | |||
![BerkshireGuy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
