Show a form next to the selected cell

[saravnepali]

Hi,

I want to show a userform to display data related to the target cell value.

I have got the code below and the form loads with values as required.

Please Login or Register  to view this content.

Is there a way to ensure that the form is displayed next to the selected cell.

Thanks in advance.

[Norie]

This will show the userform to the right and slightly above the selected cell.

Please Login or Register  to view this content.

[:) Sixthsense :)]

Copy and paste the below code in UserForm Initialize event.

Please Login or Register  to view this content.

[saravnepali]

THanks Norie and Sixthsense

It worked, only slight issue is if I cell selected on the right corner then form still goes to the right and is not visible.

I will try to put a if function to make it work.

[:) Sixthsense :)]

It worked, only slight issue is if I cell selected on the right corner then form still goes to the right and is not visible.

Revised Sheet Change Event Code

Please Login or Register  to view this content.

Revised Userform Code

Please Login or Register  to view this content.

In the above code adjust the > 500 based on your need.