Based on data from combo box , list range of value to another combo box / listbox

Hello,

I am not an expert in MACRO, however I have created a sheet and stuck now... where I have a "Area_ComboBox1". Based on the selection from this combo box, I need to list a range of data from sheet "Observation_DBS" and display in another "Observation_ComboBox" placed in a from "ObservationForm1"

Eg:
"Area_ComboBox1"
Acceptance
Delivery

Data in sheet "Observation_DBS"
ACCEPTANCE (cell A1)
1.0- FOD found on Equipments/Storage unit used in operations
1.2- Environmental standards are not followed in workplace
1.2.1- Found trash and other waste in paper recycle bin.


DELIVERY (Cell B1)
1.0- Found FOD in Recycle bin / Recycle bin not available
1.2- Environmental standards are not followed in workplace
2.0.2- Equipment checklist was not prepared / available with operator


If I select "ACCEPTANCE" I should get the data in "Observation_ComboBox" placed in the form "ObservationForm1"

Can any one help me out?

Regards./Aju

Hi Aju,

It would be good if you provide sample workbook, it will help us to give you accurate solution...

Originally Posted by Naveed Raza

Hi Aju,

It would be good if you provide sample workbook, it will help us to give you accurate solution...

Hi Naveed - I have attached the correct sample file, please have a look in it!

Rgds/Aju

Hi Ajupillai,

check out the attached file

Hi Ajupillai,

see the attached updated template