how to apply a condition for entire colomn

**pavu** · 07-22-2012, 07:32 AM

hi..
I have the following code, which pops-up a user form when we click on a cell (Eg: B2)

Please Login or Register  to view this content.

How to apply this code to entire colomn, checking if that particular cell is not filled.

**tangangtanga** · 07-22-2012, 07:44 AM

@ts if your looking for some macros that simply open the userform when you change to another cell try this, this will check if the cell is blank or filled.

Please Login or Register  to view this content.

**pavu** · 07-22-2012, 12:53 PM

hi...
Thank you for the reply...
When I tried the code, the user form is not getting populated. Can you please tell any other solution.

---------- Post added at 10:23 PM ---------- Previous post was at 08:07 PM ----------

hi...
Now the code is working fine.....
How to apply this to different colomns like,
If we click on Cells on Column-B, 'Branch' userform should pop-up
If we click on Cells on Column-C, 'Qualification' userform should pop-up
Thank you in advance......