ExcelBanter
(
https://www.excelbanter.com/
)
-
Excel Programming
(
https://www.excelbanter.com/excel-programming/
)
- -
Changing cell values
(
https://www.excelbanter.com/excel-programming/327373-re-changing-cell-values.html
)
Don Guillett[_4_]
Changing cell values
get a table
http://www.fac.unc.edu/Mail/States.asp
--
Don Guillett
SalesAid Software
"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
All times are GMT +1. The time now is
01:58 AM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com
