Multiple User Froms on Right Click event

[PaulCooke]

Could someone let me know how I can adapt the following code so that I can show a specific UserForm dependant on what cell the user right clicks please. I'm sure it is an easy fix but I am having brain block today !

Many thanks in advance

ps - there are another 4 Userforms to add into the mix as well once I know how to get them to work

Please Login or Register  to view this content.

[EssoExplJoe]

Please Login or Register  to view this content.

[PaulCooke]

Hi thanks for the reply but that is giving a compile error of Else without If

[EssoExplJoe]

Try this:

Please Login or Register  to view this content.

[PaulCooke]

Hi Thanks for your reply - I am still getting errors:-

Please Login or Register  to view this content.

this comes up as a runtime error 91 - Object variable or With Block variable not set

I have detailed the entire sub below again for info with your suggested code applied hopefully there is an easy solution to this but its got me if there is lol

Please Login or Register  to view this content.

[EssoExplJoe]

Ok..I think you are not right clicking on column 21 or 6. Try the following for column 1 and 2. Note that you must have userforms named "Userform1" and" Userform2". I tested this on a worksheet and it works when I click on column 1 or 2.

Please Login or Register  to view this content.

[PaulCooke]

Thank you so much this now works - I was definitely clicking on the correct columns before I even tried all of the columns to see if I'd made a mistake.

Thank you again though really appreciate your help on this.