How do I make a field mandatory?

Kento

New Member
Joined
Jun 16, 2008
Messages
16
Hi All,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p> </o:p>I’ve had a look through VB code on forums but found nothing that works for me. So, how do I make a field mandatory, so the user cannot move to adjacent cell without inputting anything? I need to do this for a range of cells (i.e. an entire column) which has been validated.
<o:p> </o:p>Any ideas,
<o:p> </o:p>Cheers,
<o:p> </o:p>Sam.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Several ways, depending on your need, sheet layout and data type!! Can you give specifics as to columns and such? What is the Validation of your column?
lenze
 
Upvote 0
Hi Domski,

Thanks for this - but your code restricts scrolling in all columns unless data is imputted - is this supposed to be the case?

Cheers,

Sam.
 
Upvote 0
Hi Lenze,

Here is some detail:

A2:A65536, text, validated
O2:O65536, text, validated
P2:P65536, text, validated
Q2:Q65536, number, validated
R2:R65536, text, validated
S2:S65536, text, validated
T2:T65536, text, validated
U2:U65536, text, validated
V2:V65536, text, validated
W2:W65536, text, not validated
X2:X65536, text, not validated
Z2:Z65536, text, validated
AA2:AA65536, text, validated
AB2:AB65536, text, validated
AC2:AC65536, text, validated

Is this whay you had in mind?

Cheers,

Sam.
 
Upvote 0
OK: How does the user navigate the sheet? I assume they are entering data by Rows! Is that correct? Is the sheet protected with cells in these ranges UnLocked? Are the other cells Locked?
lenze
 
Upvote 0
Hi Lenze,

The user will navigate the sheet from left to right, probably by tabbing along the row or with arrow keys.

The whole sheet is unproteted/unlocked.

Cheers,

Sam.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top