Recent content by ooops

Thank you so much. It already works.

Hi pkailas I can't do: lstViewAll.ListSubItems.add It doesn't have that property. I can see lstViewAll.ListItems but not lstViewAll.ListSubItems Any idea how I should re-write them ? Thanks so much for your help.

It still does the same thing, pushing down values of the first column to next row. This is how it looks like if the Do Loop runs 4 times. I'm really frustrated over this. It should be something simple :-(( Thanks. 4545A 4545B 4678C 4758A 123...

What I'd like to achieve is having values written to the 2 column listView (should be on the same row). The codes below don't work out right. Everytime something added to SubItem, the value in the first column is pushed down to the next row. Any help is greatly appreciated...

Hi all, I tried to use .setfocus with my textbox_keydown but it doesn't work. Any idea why ? Private Sub txtJurCode_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = vbKeyReturn Or KeyCode = vbKeyTab Then If txtJurCode.Text = "" Then MsgBox...

I tried the code and I got the column header show up but not the subitems. They are all blank :-(

I have a listView with 1 column. Please help me the way to add item in listView. The reason I'm trying to use listView instead of listbox b/c in VBA listbox does not have sort property. Thanks so much for your help.

I tried listView like you suggested but I really have problem adding item to the listView. Suppose I have only 1 column in listView and I'd like to add a list of item just like what I did in listbox. Could you show me how. Thanks for your help.

Hi, This is what I currently have: For i = 0 to lstBox1.ListCount -1 lstBox2.AddItem lstBox1.Text next i lstBox2 is a multiple column listbox. How do I remove all the items in lstBox1 to column(1) of lstBox2 ? Thanks a bunch for your help.

Hi, Do listbox limit the ammount of item we can add ? What's the max number ? Thanks.

Hello all, Please help me the code to allow users enter only number in the textbox. I know it's a keydown event but I can't find the ASCII code to do this. Thanks in advance.

Hello all, Could you please show me how to set focus on a specific row and column ? (in my case I need to set focus on the second column of the last row) Thank you so much.

Hi, How do I open a form with new record from another form ? Thanks.

Thank you all. I got it! :-)

Thanks for your help. Could you please give me the code to cancell the operation ? I've had a hard time finding it. Thank you so much.