Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell values
Hi
if you'ld to post all your code then it might help figure out a solution .... things to check in the meantime tools / macro / macros - security set to medium or less and you choose enable macros on open in the immediate window type (VBE Window / view / immediate window) application.enableevents = true and press enter -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "D" wrote in message ... Hello. I have a cell list of states, from data validation, that a user created and now would like when a user types the state or selects the state from a drop-down list, it converts it to the abbreviation of the state. I have an If ActiveCell.Value = "Alabama" Then ActiveCell.Value = "AL" but it doesn't seem to be working. ??? Don't know why? I thought this would be easy but not sure now. Well hope you can help. Thanks, -- D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell for Changing Multiple Values in other columns | Excel Worksheet Functions | |||
Need to store changing values from one cell | Excel Discussion (Misc queries) | |||
changing cell values | Excel Discussion (Misc queries) | |||
Changing values in a row based on a cell in the row. | Excel Discussion (Misc queries) | |||
Changing Values In A Cell | Excel Programming |