VBA for combo box

[arnab0711]

Hi,
I have this chart,which has two sheets,chart and master,now in the chart sheet I have two combo boxes in row 3,the combo box will have contents in cells A2,A12,A22,in "master" sheet and when selected it will give array A3-D10 or A13-D20,or A23-D30
for example when selected BTS it will show contents of master sheet (A4-D10) in sheet chart from cells C8-E14,likewise if we select combobox 2 well want to keep
A1 and F1 and also the contents

[slamet Harto]

how about using data validation

see this and hoping its help

[arnab0711]

Its working fine for BTS and MW,but not working for antenna

[slamet Harto]

you can change "Antena" with "Antenna" thru data validation.

in cell D4, select Data Validation, and edit Source to BTS,ANTENNA,MW then ok

[slamet Harto]

here is the revision