EXCEL-LENCY
Board Regular
- Joined
- Feb 9, 2010
- Messages
- 75
Hello,
I have a combobox "VIEW_ITEM_DETAIL_CMB_BX" on the sheet Output that has VBA Code Name "OUTPUT_PAGE". I want to populate that combobox with the dynamic range I've defined as "DYN_COST_DATABASE_ITEMS". This code works when I am populating comboboxed on a userform, but when the combobox is on a sheet, it doesn't work. Help would be greatly appreciated!!
Dim Otpt As Worksheet
Dim Cmb_Bx_Value As Range
Set Otpt = OUTPUT_PAGE
For Each Cmb_Bx_Value In Otpt.Range("DYN_COST_DATABASE_ITEMS")
With Otpt.VIEW_ITEM_DETAIL_CMB_BX
.AddItem Cmb_Bx_Value.Value
.List(.ListCount - 1, 1) = Cmb_Bx_Value.Offset(0, 1).Value
End With
Next Cmb_Bx_Value
Thanks!!
Jason
I have a combobox "VIEW_ITEM_DETAIL_CMB_BX" on the sheet Output that has VBA Code Name "OUTPUT_PAGE". I want to populate that combobox with the dynamic range I've defined as "DYN_COST_DATABASE_ITEMS". This code works when I am populating comboboxed on a userform, but when the combobox is on a sheet, it doesn't work. Help would be greatly appreciated!!
Dim Otpt As Worksheet
Dim Cmb_Bx_Value As Range
Set Otpt = OUTPUT_PAGE
For Each Cmb_Bx_Value In Otpt.Range("DYN_COST_DATABASE_ITEMS")
With Otpt.VIEW_ITEM_DETAIL_CMB_BX
.AddItem Cmb_Bx_Value.Value
.List(.ListCount - 1, 1) = Cmb_Bx_Value.Offset(0, 1).Value
End With
Next Cmb_Bx_Value
Thanks!!
Jason