This bit from VBA help seems to say that LBClerk1.Value or LBClerk2.Value and
BoundValue are one and the same.

[BoundValue applies to the control that has the focus.

The contents of the BoundValue and Value properties are identical most of
the time. When the user edits a control so that its value changes, the
contents of BoundValue and Value are different until the change is final.]



"C Brehm" wrote:

Have the following code that works fine

Worksheets("daily").LBClerk1.Value = .Range("s" & rc).Value
Worksheets("daily").LBClerk2.Value = .Range("t" & rc).Value

LBClerk1 and 2 are listboxes.

While the value is set correct the boundvalue is not.
How do I set the boundvalue so the right value will show on the worksheet?