Userforms again !

[rollo]

Have already checked through 200+ previous posts but cannot find the info that I need.
I have a worksheet which has existing data in columns A & B. I need to set up a userform which will display the existing data from columns A & B, and then allow a user to select Yes or No from a dropdown list (or similar), with the response going into column C

A.................B...............C
Dept............Number........Yes or No
Dispatch..........1
Accounts..........0
Export............1
Supplies..........1
Journal...........0

The userform needs to appear when the user opens the worksheet. This userform needs to be set up so that the user will see the existing data in each of the cells in Col A & B (first to last cell). Users must make a response of Yes or No before the next records are displayed (if no response is made, ideally a message should appear asking them to enter a response).
The populated cells in cols A & B can be variable.
Finally, a user must not be allowed to close the worksheet if no response has been made to any of the corresponding cells in col C.

Would greatly appreciate any help ……. many thanks!

 

[rollo]

Still no joy ...... looks like I'm the dimwit causing the problem. Will go back and check through everything again.
Yes, Paddy ....... I did mean close the workbook rather than worksheet. My apologies.
Many thanks to all of you for your help .... will post when successful.
rollo

 

[Colo]

Hi rollo, just put this code into ThisWorkbook module instead of "Private Sub Worksheet_Activate()".
It makes Userform1 be shown when workbook is opened. That's it.

<pre>
Private Sub Workbook_Open()
Userform1.Show
End Sub
</pre>

 

[rollo]

Hey, Colo ....... that's absolute magic!!!!
Thank you so much! Thought that I had lost the plot!
Cheers ....... rollo