Create a pop up comment

[Alice21]

Hi

I am creating a tool that collates bed numbers on a ward. There is a column that needs to be completed (with a number) if the ward has any closed beds.

I want to have a comment box to pop up that states "Please select reason for bed closure from drop-down box" when a number is entered into the 'beds closed' cell.

Is this possible?

Thanks!

[stephaneg]

Hi Alice,

One way of doing it without adding any buttons on your sheet could be by calling an inputbox (drop down box) in the "beforeclose" event of your workbook.

Do you see what I mean?

Stephane

[Andy Pope]

You would need to use a userform to display a list of choices.
The userform could be display by using the Change event of the worksheet.

Right click sheet tab and pick View Code. Paste the following, which will work for changes in the range B2:B4

Please Login or Register  to view this content.

Or you could use Data Validation in the cells which require a reason and use conditional formatting to draw users attention to cell when a value is entered.

[Alice21]

Hi Andy

The example you have given below is for a range of B2:B4. The issue i have is that there are 5 areas completing the information so I only want the mesage to pop up when people enter into their own areas.

I.E - Area 1 enters into cells C13:C21
Area 2 enters into cells C26:C43

So if Area 1 enters a number in to the C column 'Beds Closed' I want a message to pop up to remind them to complete the 'Reasons/Comments' box.

Does this make sense?
Thanks

[Andy Pope]

Add more checks for the areas.

Please Login or Register  to view this content.

[Alice21]

Worked like a dream! Thank you very much!