If functions

Hi,

I'm a complete beginer when it comes to VBA but i'd like to be able to fill a list box with information depending on the value of a cell. From reading the previous entries that could be useful an if function seems to be the way to go but i'm stuck. I don't know the syntax or code that would allow me to check a range of cells and if that cell has a certain value in it place informatio in a list box on a user form. Can anybody help me please?

cheers,
Matt