S
Scott
I keep getting intermittent error when trying to assign
the LinkedCell value to a combo box. I want the linked
value to be in the current row so I put the code in the
Worksheet_Selection Change event.
Select Case obj.Name
Case Is = "ComboBox7"
Case Else
obj.LinkedCell = Cells(theRow, theCol).Address
End Select
This works sometimes but when I select from the drop down
#N/A appears in the linked cell. Other times I get this
error.
Method 'LinkedCell' of object '_OLEObject' failed
I need to put the text value of the drop down in one cell
and the second column value in the next colum. I
populated the drop down with a pre-written list of values
on another sheet.
Would you please include code with your help?
Thank you!
Scott
the LinkedCell value to a combo box. I want the linked
value to be in the current row so I put the code in the
Worksheet_Selection Change event.
Select Case obj.Name
Case Is = "ComboBox7"
Case Else
obj.LinkedCell = Cells(theRow, theCol).Address
End Select
This works sometimes but when I select from the drop down
#N/A appears in the linked cell. Other times I get this
error.
Method 'LinkedCell' of object '_OLEObject' failed
I need to put the text value of the drop down in one cell
and the second column value in the next colum. I
populated the drop down with a pre-written list of values
on another sheet.
Would you please include code with your help?
Thank you!
Scott