Listbox Display

[keilah]

Hi

How do you fix the displayed data in a form window via the macro field and not the form properties....in listbox....

it keep on moving around once a delete any row in the worksheet (above the form)

thanks

[Bob Phillips]

Do you mean something like

[vba]

With Me.ListBox1
.AddItem Format(myAmt,"$#,##0.00")
End With
[/vba]

as a very simple example?

[keilah]

yes....

may data is in the following range

s400:u427

[Bob Phillips]

I thought you said a form listbox?

[keilah]

thanks fo the feedback....

fixed the problem with your help.............

[geekgirlau]

Just a quick note for future entries - make sure you give your post a title that tells us something about the problem. A generic "Help" topic doesn't tell us anything, and is less likely to get responses.