Numbers in a listbox cell

Hello everyone

I am grateful for the interest and scope of the following:

How can I make a particular column of a listbox, only allow entering numerical data?

Any ideas will be greatly appreciated.

Raúl Juárez Pulache

Filter the pressed key in the KeyDown (or KeyUp; its late for me) Event and reject unwanted keys (Accept 0 thru 9, comma, dot, space, whatever, rejet everything else) ?

You can apply a mask to the active cell of the listbox ( Apply the mask in the CellGotFocus Event handler (


me.ActiveCell.Mask = "999999"

Thank you very much
Wayne Golding

With Me.ActiveCell.Mask in the CellGotFocus Event, I solved the problem


Raul Juarez Pulache