message prompts in VBA

[VBAmalta89]

I have a user form and I need to check a value of a cell in a particular worksheet when the user inputs chooses data from a combo box.

If the value of this cell in the worksheet is >0 then a message is prompted otherwise the program can continue normally.

How can i do this in VBA?

 

[VBAmalta89]

ok your code seems to be working but there is one slight problem.

What if it needs to check column D rather than column B, how do i alter the code?

and how do i change the row number

 

[Andrew Poulsom]

To look in column D:

If Range(.RowSource).Cells(.ListIndex + 1, 4).Value <= 0 Then

I do not know what you mean by "change the row number".

 

[VBAmalta89]

what i mean is what if the data was in cell D70 then how do i reference that?

 

[Andrew Poulsom]

Why would it be in D70? You can reference it in the same way I referenced B34 in my original code.

 

[VBAmalta89]

never my mistake i got confused for a while that why.

It worked perfectly for me

thanks very much for your help and time