Listbox help
 

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?

Listbox help
 

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?

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

"JLGWhiz" wrote in message
...
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?

Listbox help
 

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.

"C Brehm" wrote:

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.

"JLGWhiz" wrote in message
...
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?