PDA

View Full Version : Listbox Display



keilah
08-20-2007, 01:46 AM
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
08-20-2007, 02:25 AM
Do you mean something like



With Me.ListBox1
.AddItem Format(myAmt,"$#,##0.00")
End With


as a very simple example?

keilah
08-20-2007, 02:54 AM
yes....

may data is in the following range

s400:u427

Bob Phillips
08-20-2007, 04:31 AM
I thought you said a form listbox?

keilah
08-20-2007, 04:50 AM
thanks fo the feedback....

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

geekgirlau
08-20-2007, 05:16 PM
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.