listview userform was not working

Re: listview userform was not working

You mean something like this??

Re: listview userform was not working

If you create the userform in this pc, i don't know why it gives you the message. Maybe you changed something?

Go t vba editor and check your references under tools. There must be a missing thing.

Try to rebuild the userforn yourself. Not copy/paste.

Re: listview userform was not working

Can you sent a sample of your workbook?

Re: listview userform was not working

Sounds like your UserForm has a datePicker or similar on it which is not available on that PC

Re: listview userform was not working

You have changed the declarations, they should be integers, it looks like you are trying to set them not declare them

ByVal x As stdole.OLE_XPOS_PIXELS, ByVal y As stdole.OLE_YPOS_PIXELS

These properties do not exist for a ListBox in Excel VBA

'Define ListView appearance
Me.lvwTest.View = lvwReport
Me.lvwTest.FullRowSelect = True
Me.lvwTest.Gridlines = True
Me.lvwTest.HideSelection = False
Me.lvwTest.ColumnHeaders.Clear

I believe you have tried to use code that applies to a different program

Re: listview userform was not working

You used a listbox than a listview. It is copmletely different...
In your sample, I delete the listbox and put a listview with the same name 'lvwTest' and without change anything else, it works.

You must use a listview! In your toolbox, go to 'Additional Controls' and check the ' Microsoft ListView Control, version... '. Then you can see it in toolbox.