ExcelBanter - how do I prompt a user to update a cell in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I prompt a user to update a cell in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/44887-how-do-i-prompt-user-update-cell-excel.html)

martb

how do I prompt a user to update a cell in Excel?

Dave Peterson

I'd use an adjacent cell formatted in big red letters:

=if(a1<"","","Please enter a value in A1!")

martb wrote:

--

Dave Peterson

All times are GMT +1. The time now is 06:53 PM.