Listbox help

[C Brehm]

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?

 

[JLGWhiz]

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]

I understand that, But I need to make the changes final and the selection to
show in the listbox..
I can find no way to set boundvalue , If I run the code and exit the
workbook, It shows right when I open the workbook.
There must be a code command (that I can't find) to set the boundvalue.

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.]

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?

 

[JLGWhiz]

You probably want to work with the ListIndex. You can use that to set the
value of the listbox or combobox. Check that out in VBA help.

I understand that, But I need to make the changes final and the selection to
show in the listbox..
I can find no way to set boundvalue , If I run the code and exit the
workbook, It shows right when I open the workbook.
There must be a code command (that I can't find) to set the boundvalue.

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.]

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?