Visual Basic - Not allowing cell entry

Hello again,

So I am still working on the same sheet and my question is as follows:

I have a cell that I do no want anyone to enter any information into unless a previous cell has "U" inside of it. I know, I know confusing.

Okay so so I have a column of cells named "Fringe Benefit Type" you can choose different letters to corropand to different types. Now I have set the letter "U" to be the one I want and that works. Now the next cell is called "Hire Season". Now (stay with me here) IF "Fringe Benefit Type" is equal to "U", I don't want the user to be able to enter anything into "Hire Season".

I am using the visual basic thing, which already has some code, but I am not understanding it too well.
Any help would be appreciated.
Reply With Quote

How about posting the code, and explaining what happens that you don't like?

Originally Posted by shg

How about posting the code, and explaining what happens that you don't like?

Thats the thing, I don't know much at all about the code, so I was hoping that someone could get me started...

What column is "Fringe Benefit Type" in? What column is "Hire Season"?

You're aware that if you use code to modify a worksheet, the Undo stack is flushed, and that's OK?

Originally Posted by shg

What column is "Fringe Benefit Type" in? What column is "Hire Season"?

You're aware that if you use code to modify a worksheet, the Undo stack is flushed, and that's OK?

Fringe Benefit is Starts at cell P23 thru P62. Hire Season is R23-R62.

That is fine,
Thanks!

Right-click on the sheet tab and paste this in the window that opens:

Please Login or Register  to view this content.

1. I meant to say this before: Please quit quoting whole posts. It just clutters the forum.

2. Please read the Forum Rules and then edit your post to wrap your code with Code Tags.

3. You can only have one Worksheet_Change event.

How do I change it so that it does not have a Worksheet_Change event?

2. Please read the Forum Rules and then edit your post to wrap your code with Code Tags.

How do I change it so that it does not have a Worksheet_Change event?

You have to merge the code in the two subs together so that the single event does everything you need done.

Okay, done

Thank you.

Did you write the other worksheet change code?

I honestly don't know how. I need to be walked thru this I think. So the code is appearing exactly like the following:

Please Login or Register  to view this content.

Please let me know exactly what I have to do to make it work. Thanks.

Delete this, it's not doing anything:

Please Login or Register  to view this content.

Change all the Exit Sub statements to

Please Login or Register  to view this content.

Then add this line before my code:

Please Login or Register  to view this content.

This is what I have now:

Please Login or Register  to view this content.

Now its not doing anything.

Okay this is what I have:

Please Login or Register  to view this content.

Now it is still giving me the Ambigious name detected: Worksheet_Change
How would I change that?
Thanks!

Please Login or Register  to view this content.