Reply to thread

Message: [QUOTE="sam, post: 6125987"] Hi, I tried this code again. The result showing on the listbox2 is something like Sheet2!$B$2:$B$6. What i want to present in the listbox is the value from the the range. because this range is variable. it depends on the choice in listbox1. So i use a cell(named DetailInfoAddress") in sheet2 to represent the range. based on differest choice on listbox1, the value in the cell "DetailInfoAddress" can be "Sheet2!$B$2:$B$6", "Sheet2!$B$7:$B$10","Sheet2!$B$11:$B$15",etc. Then I want show the value in the specific range like "Sheet2!$B$2:$B$6"or "Sheet2!$B$7:$B$10",etc. Do you get my problem? Thank you!!! Best Regards Sam [/QUOTE]