Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

do not want blank cells?

Status
Not open for further replies.
bgreen

bgreen

Programmer
Feb 20, 2003
185
CA
How can I prevent a user from leaving a cell blank (empty)?

I would like column A to not allow any blank cells. Preventing end user from entering data into a cell if there are any empty cells above it.
 
Sort by date Sort by votes


Hi,

You cannot do that without VBA code.

If you wish to pursue a code solution, please repost in VBA Visual Basic for Applications (Microsoft) Forum707.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
334
combo
combo
N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
627
N1GHTEYES
N1GHTEYES
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
601
SkipVought
S
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo
bhujanga
  • Locked
  • Question
Does Excel Cancel Just not Work?
Replies
0
Views
234
bhujanga
bhujanga

Part and Inventory Search

Sponsor

Back
Top