How do I make a field mandatory?

[Kento]

Hi All,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>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> </o>Any ideas,
<o> </o>Cheers,
<o> </o>Sam.

 

[lenze]

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

 

[Domski]

...

 

[Kento]

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.

 

[Kento]

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.

 

[lenze]

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

 

[Kento]

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.