Inserting value in a cell when element is picked from a dropdown list in another cell

You should post a worksheet. You can replace any sensitive data with dummy data. Make sure you are showing and explaining where and what you want the results of the changes in the drop down list to be.

No I meant worksheet(the file), I can't test a picture or tell if there are any data issues or other things I should be aware of with a picture. I don't want to spend my time trying to recreate your sheet from scratch. You can make a copy and if you have sensitive data just replace it with dummy data. If you have hundreds of rows etc just delete most of them but be sure to leave enough to show what you need.

To post a file reply to this thread, click the Go Advanced button and select the paperclip icon.

View Pic

hi there adriano.r.marques
try this code in your worksheet change event:

Please Login or Register  to view this content.

Originally Posted by adriano.r.marques

Oh! Wow! I didn't know that. Thanks for the explanation.
So here's the file.
Thank you.
Attachment 402942

Okay if you right click on the worksheet name tab and choose view code, then you can paste this into the window that comes up. You might see your other code and that will tell you that you are in the right place.

This simply first of all checks to make sure you changed only one cell and that the cell you changed was from E3 to E500, you can change that if it's too much or too little. If the value of the cell is BRL you get n/a in M-P if not it's empty.

Please Login or Register  to view this content.

hi there skywriter
still your code does not prevents the users from modifying values in M-P columns

Originally Posted by bulina2k

hi there skywriter
still your code does not prevents the users from modifying values in M-P columns

It's not meant to, he has data validation in place.
He was using a formula to put n/a in the cell if someone picked BRL, the data validation keeps them from entering a value. The problem is if they pick something other than BRL then those cells can be manipulated, but in so doing destroys his formula, so n/a will no longer be in the cell if it gets changed back to BRL.

Glad you are happy.

If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.

Hi, guys. Sorry to bother you again with this. As I thought I was a smartass, I tried to apply the VBA code yous guys created in another function but it isn't working.
This time I want cells in column R to show either "C" or "O" depending on the value selected from a list in the same row in column Q. So if user selects either "Canceled" or "Withdrawn" in column Q, same row column R shows "C". If any other value is selected from the list in column Q, then user can select (or type) either "O" or "C" in same row column R (ideally, cell would show "O" as default). Finally, if none value is selected from the list, then same row column R is blank.

As to start out, I decided to test whether one of these would work out by editing the previous code you guys provided:

Please Login or Register  to view this content.

Obviously it didn't work. What am I doing wrong?

hi there!
I think you should use select case statements (in Worksheet_Change event):

Please Login or Register  to view this content.

as you can see (from your picture) there is already code in Worksheet_Change event (skywriter's code) so because you can't have two Worksheet_Change subs you will have to use that same sub.
Put my code:

Please Login or Register  to view this content.

right before 'End sub' (and of course delete the second Worksheet_change)

Hi bulina2k. Thank you so much. It's working beautifuly.
I'm curious about something. When I select one single cell in column Q and hit the delete key, whatever is in the same row column R is automatically gone. However, when I select multiple cells in column Q and hit the delete key, whatever is in the same row column R is kept. It happens with previous skywriter's code too. It isn't a problem at all as I can always delete it manually, but why is that?

Again, thank you for your help.