can not get vb 2 run, testing cell string match, then trying 2 write new value in new cell

I have written some VB to check an entry from a drop down list. the first sub converts lowercase to uppercase (this is working), then I wish to check string from dropdown to hard coded strings, and if match, write a single hard coded character to new cell on same page, and write another hard coded value to another cell. The case conversion works fine, but not the next sub to check strings... once that works I think I know how to write hardcoded characters to cells...

Please Login or Register  to view this content.

Hello regupnorth,

Welcome to the Forum!

What results are you are getting from the macros when they execute?

Maybe:

Please Login or Register  to view this content.

Regards, TMS

If nothing happens, it sounds as though your event handling has been switched off.

Regards, TMS

Well, it won't ... it's an event handler

Type that command into the immediate window and press enter.

The try.

In the VBE, press Ctrl-G. You should get a little window under the code pane. Type in there. Or you can press View on the menu.

Hello regupnorth,

Did you enable VBA macros in the Trust Center?

How to Change macro security settings in Excel 2010

Have done that.
Also, first sub runs OK.
Still nothing to show second one is even running...

Hello regupnorth,

If your worksheet is not protected then you should post your workbook for review.

How do I do that? Just paste it into here?

Hello regupnorth,

The code in the workbook runs. It probably is not running the way you intended it to. When the user selects "Battery" from the validation drop down, this triggers the Worksheet_Change event. The code you have in this event converts the entry in cell "B" to uppercase. This works as you said.

The second part of what you want, to copy the cell contents from cell "B" to "C", is controlled by the Worksheet_SelectionChange event. This event is fired only when the cursor is moved to another cell and the users clicks that cell to select it. Select "Battery" in cell B14. Click cell B15 and then go back and click B14. It will copy over to C14.

Hello regupnorth,

I think it would be easier to do this using a UserForm to control the data entry the way you want and then transfer it to the worksheet. With the UserForm you could make use of the ActiveX ComboBox which will automatically match an entry in the list as you type.

Thanx. I did just that. Now I am back to where, based on the item selected in the combobox, I want to test it, I assume with an IF, and based on the match, I want to populate a text box as the focus goes to that textbox, with a character hard coded in the THEN, followed by an OR IF, and so on.... Where would I put this code?