Combo Box Search and list down

Hai

Refering previous thread,

http://www.excelforum.com/excel-prog...html?p=3245862

----------------------------------
'Select Case LBValue
'Case "data1"
'dataRng = "Namesdata1"
'Case "data2"
'dataRng = "Namesdata2"
'Case Else
'dataRng = "Namesdata1"
'End Select
dataRng = "Namesdata2"
---------------------------------

If i change formula Namesdata1 to Namesdata2, the result value will be from data2 sheet. but if i change the sheet name from data1 to data2, to result still from same sheet, it seem changing sheet name doesn't effect the result. I try to find the range column of seach function in via developer-design mode and 'project explorer' & 'properties window' from window VB, but seem no range of column being set. so how do i want to search on different sheet and different column.

TQVM!

Originally Posted by HaHoBe

Hi, acrylic26,

have a look at the NameManager for the dynamic lists the code refers to (and the areas they work in).

HTH,
Holger

oowh, this is new for me, i tried to figure it out within VBA almost a week. thank you very much sir.