Pop-up User Form

[robertguy]

Hi,

What I am after is a user form that pops up when I enter ‘Y’ in cells in Column ‘L’ which displays the contents of the cells in that row e.g. if I enter Y in cell L2 a user form would pop up displaying the contents of cells A2 to M2


The A2 to M2 column headers are:-

First Name
Surname
Code
Address line 1
Address line 2
Address line 3
Address line 4
Address line 5
Post code
Telephone
Comments

The user form can be Read only i.e. I do not need to edit the cells (although that would be good) as it will be used as a source document to input into another application, however, a ‘Print’ button to print the form would be beneficial. The only other button required would be a ‘Close Form’ option.

Any assistance in this matter would be greatly appreciated – please see attached example file.

N.B. Excel version 2003

Many thanks


Rob

[robertguy]

"Bump no response"

[Andy Pope]

maybe because it's been covered many times and you haven't had a stab at it yourself, who knows

sheet event code

Please Login or Register  to view this content.

Userform1 has listbox (2 columns) and commandbutton.
code

Please Login or Register  to view this content.

[robertguy]

Andy,

many many thanks for you prompt reply it is very much appreciated.


Your code works excellently and is just what I wanted and will save me many hours of scrolling back forward searching for data in a particular row.

Many thanks


Best Regards

Rob

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save