How to prevent column resizing

General
1

Hi,

Is there any way to prevent user from resizing listbox(Jeremie) columns?
It keeps changing the first row-first column value whenever columns are resized.
Tried to code like below, but I can resize it.

– Open event(listbox)
Me.ColumnsResizable=false
Me.Header.ResizeValue=0
Me.Header.ColumnsResizable=false

On a normal listbox, I don’t see this issue though.
I’m looking for a workaround.

Please help me out.

2

[quote=187640:@changwon lee]Hi,

Is there any way to prevent user from resizing listbox(Jeremie) columns?
It keeps changing the first row-first column value whenever columns are resized.
Tried to code like below, but I can resize it.

– Open event(listbox)
Me.ColumnsResizable=false
Me.Header.ResizeValue=0
Me.Header.ColumnsResizable=false

On a normal listbox, I don’t see this issue though.
I’m looking for a workaround.

Please help me out.[/quote]

Chances are returning true in Mousedown when the mouse is over the header will do the trick. Otherwise you want to ask Jeremie.

3

Jeremie never responded…-.-

MouseDown(X,Y) as Boolean…
Can you let me know in more detail? How can I check if the mouse is over the Header and call MouseDown event in there?

4

I will assume the header is the same size as the regular listbox. This is the event of the listbox.

Function MouseDown(x As Integer, y As Integer) As Boolean if y < 20 then return true End Function