Multi cell check VBA

[kipper2]

I need to check the value in four differant cells. If the value in each of all four cells is greater than 1. then to complete one of two tasks based on the value.

I just what to check that the information has been entered. have been using the following will work on one cell but not any more.

Please Login or Register  to view this content.

Can anyone help
Edit/Delete Message

[TMS]

One way:

Please Login or Register  to view this content.

Regards

[kipper2]

New to VBA
Thanks inadvance for any help

I have a drop down table that is used in a spread sheet, The option on the list is please select. I would Iike to be able to reset the box to this when it saved.

[TMS]

How does that relate to the question I have just answered?

It looks as though it warrants a new thread.



To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!



Regards