Prevent selection of cells, based on value of another?

G

Guest

Is there a way to prevent the selection of certain areas of a form, based on
the value of an entry in one cell?

Say, if B1 is less than 3, then I want the user of the form to tab right
past the four next spaces. I've made them invisible based on the value of B1
already with conditional formatting, but it would be nice if you could hit
the tab button without "stopping" at these cells.

THanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding fill to cells only when value is "No" in another cell 1
shading a cell or group of cells based on value 5
Format a blank cell based on the value of another cell 2
conditional format on column based on cell value 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
How do I Keep a Combo Box "Focused" on difrferent cells. 5
Conditional Format for one cell based on range 3
Formula (off form) that completes form data based on a result 2

Top