ExcelBanter - In Excel, how can I require a field to contain data?

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

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

- - In Excel, how can I require a field to contain data? (https://www.excelbanter.com/excel-discussion-misc-queries/237609-excel-how-can-i-require-field-contain-data.html)

mswanson

In Excel, how can I require a field to contain data?

Gord Dibben

In Excel, how can I require a field to contain data?

Data Validation could be used.

Select B1 and Data ValidationCustom

=COUNTA(A1)0

Add an error alert "A1 must be filled before entering data in B1"

Gord Dibben MS Excel MVP

On Tue, 21 Jul 2009 14:06:01 -0700, mswanson
wrote:

All times are GMT +1. The time now is 08:19 PM.