Help with VB codes and Validation Data

R

Rich9016

Hi everyone,
I was wondering if anyone could help me out with a chart I'm trying t
develop.

The attached file is a chart that I eventually want to use to trac
physical therapy patients. Ideally, I would like to be able to choos
a name, then an injury and then the side and then have that patients
worksheet come up. All the while, all the other worksheets will remai
hidden. At the start, the only sheet that is not hidden will be th
"start" sheet. I've heard I need to use VB code for all this but I'
not experienced with that at all.

Also, I'd like to make it so that B3, B4 and B5 are dependant on eac
other in subsequent order? In other words, one can only enter data i
B4 if B3 is first filled in and B4 must have info before B5 can b
chosen. And if B3 is deleted, then B4 and B5 will be blank and if B
is deleted then B5 will be blank.

Lastly, my warnings don't seem to work for the B3 and B5 cells, onl
B4. What I'm doing wrong?

I hope all this makes sense. If anyone can help me out I would greatl
appreciate it. Thank you in advance.

Ric

Attachment filename: pt exercise chart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63294
 
D

Debra Dalgleish

You're not getting error messages because your list range contains blank
cells. If you left the cells to accommodate items that might be added
later, you could use a dynamic range instead. There are instructions here:

http://www.contextures.com/xlNames01.html

To prevent the dropdowns from being used in the wrong order, you could
create a range named "None", with a single cell that contains the word "N/A"

Then, in the data validation for cell B3, change the formula to:

=IF(AND(B4="",B5=""),NamesCol,None)

For B5, use the data validation formula:

=IF(AND(B3<>"",B4<>""),SideCol,None)
 
Top