Hello
I have a named range on a worksheet named "LookupLists"
Actually, there are 2 named ranges that point to the data that I am trying to capture within the combobox: (btw I found this formula on another thread here on this board... I used this particular code because my data within the named range will change frequently and this was what I was directed when I did a search on here... if there is a better/easier way of doing what I am trying to do, then please feel free to make any suggestion. )
The first one I have named "Size"
it refers to:
=MATCH(9.99999999999999E+307,LookupLists!$T:$T)-ROW(LookupLists!$T$1)+1
the second on I have named "Data"
it refers to:
=OFFSET(LookupLists!$T$1,0,0,Size)
On my main worksheet, I have a combobox named "cboName"
I have the ListFillRange property blank
Here is the code I have on the worksheet where I have the combobox "cboName" (which is on a different worksheet where the named ranges are located)
Here is the complete property settings for my combobox "cboName"
Thanks for any help and/or suggestions
I have a named range on a worksheet named "LookupLists"
Actually, there are 2 named ranges that point to the data that I am trying to capture within the combobox: (btw I found this formula on another thread here on this board... I used this particular code because my data within the named range will change frequently and this was what I was directed when I did a search on here... if there is a better/easier way of doing what I am trying to do, then please feel free to make any suggestion. )
The first one I have named "Size"
it refers to:
=MATCH(9.99999999999999E+307,LookupLists!$T:$T)-ROW(LookupLists!$T$1)+1
the second on I have named "Data"
it refers to:
=OFFSET(LookupLists!$T$1,0,0,Size)
On my main worksheet, I have a combobox named "cboName"
I have the ListFillRange property blank
Here is the code I have on the worksheet where I have the combobox "cboName" (which is on a different worksheet where the named ranges are located)
Code:
Sub WorkSheet_Activate()
Worksheets("Seatex Incident Log").OLEObjects("cboName").ListFillRange = "Data"
cboName.ListIndex = 0
End Sub
Here is the complete property settings for my combobox "cboName"
Thanks for any help and/or suggestions