I want display a word in H column when a specified words comes in P column

[vengatvj]

I want display "CORP" in H column when this word "IN Enterprise Employee" comes in P column. how to make a VBA to do the above function.

[Decar]

Please Login or Register  to view this content.

is that what you ment?

[JOHN H. DAVIS]

Or if you are looking for event code.

Please Login or Register  to view this content.

[vengatvj]

Hi if you dont mind, could please give me sample file? i tried myself, i applied your code. not working may be i did wrong.

[JOHN H. DAVIS]

Hi if you dont mind, could please give me sample file? i tried myself, i applied your code. not working may be i did wrong.

Which poster are you refering too?

[Decar]

John H. Davis one is probably the one you wanted but I just put both in. Obviously you have to first disable John's or delete it before it makes sense to press my button ^^


corp_in_h.xlsm

[vengatvj]

I was telling about both of you code. Your sample file also not working. I write in P column as "IN Enterprise Employee" but not coming the word "corp" in
H column. I want like this. see my sample file

[JOHN H. DAVIS]

Maybe; Try it now.

[vengatvj]

Is it possible? superb.. Thanks a lot John, its working well. thanks a lot..

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[vengatvj]

I was spent my time in your vba program. Sorry. i came back here again to close this thread. and a small question again. i can't delete multiple cell at same time while your vba running. its shows debug error when i try to delete multiple cells, I select end program then delete and again run your vba code then it will work. any options there to solve this? this is my long time question. i met this problem many time

[JOHN H. DAVIS]

Replace the sheet event code with this;

Please Login or Register  to view this content.

[vengatvj]

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

A error message occurred when i joint above VBA code. What should I modify and joint the above vba. ?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[vengatvj]

ya ya ya... very very very Good great, your post no # 12 is working great. i can delete multiple cells. but your last code post no #14 is unable to delete multiple cells, Could you Please modify that too?

[JOHN H. DAVIS]

Please Login or Register  to view this content.

[vengatvj]

i tried your last program, "corp" word not display, and unable to delete multiple cells.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[vengatvj]

Boss, I can delete mulitple cell without error. but i met a new problem that is, all multiple cells deleted also replaced text. this word display "250/250" and "Deposit-Acif"


Its ok i can managed. Its enough to me. if possible solve this later. have your own time.

[vengatvj]

Hi a problem happened in this VBA code. its not working when P column is lookup. if i type manually "IN Enterprise Employee" then display "corp"
but if i get "IN Enterprise Employee" this from lookup then not showing this "corp" in in H column. check attached file

[vengatvj]

Please Login or Register  to view this content.

This code wont work when my data in lookup formula In P column, if i type manually in P column then working, but if match vlookup then wont display "corp" in H column. Please modify