Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repost of listbox losing linked cell
I apologize if this is a duplicate of a message from an hour ago. Ithas not
been posted yet and I am desperate. I have a listbox with a linked cell of AK5. The listbox is not in a userform. It is taken from the Control Toobox bar and placed on the worksheet itself. I have named it lbFinCarrier. In the Formula box it shows "=EMBED("Forms.ListBox.1","")" For some reason, it loses its connection to the linked cell AK5. I can scroll through the listbox and the value in the lnked cell does not change. Sub FillListBoxCarriers() Dim wb As Workbook Dim ws As Worksheet Dim strListRange As String Dim OLEObj As OLEObject Set wb = ThisWorkbook Set ws = wb.Worksheets("Inputs") ws.Select strListRange = "AK6:AK39" Set OLEObj = ws.OLEObjects("lbFinCarrier") With OLEObj .LinkedCell = ws.Range("AK5") .ListFillRange = ActiveSheet.Range(strListRange).Address(external:= True) End With Set OLEObj = Nothing Set ws = Nothing Set wb = Nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero in cell where it is linked to a blank cell - repost | Excel Worksheet Functions | |||
Listbox linked cell does not change | Excel Worksheet Functions | |||
Repost of Listbox Headers | Excel Programming | |||
ListBox (finding Repost) (try to line up my example) | Excel Programming |