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

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

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

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