Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a visual basic code....please
Can someone write me a visual basic code that will do the following on a
spreadsheet that already has data? A column for "Tube Type" default is SST (this is in a validation list), how can I change the entire spreadsheet to automatically default to from "SST" to "Green" (the word, not the color) rather than SST. So rather than all the columns taht default to SST, I want them to automatically default to Green. I tried everything I can think of but someone said I probably need a visual basic code to do, HELP!! Rhonda Randolph Medical University of South Carolina |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a visual basic code....please
If you have cells that contain SST and you want to change then read Green
then Edit - Replace will do that. If you want SST to change to Green when SST is entered then try Auto-Correct. Mike "Rhonda" wrote: Can someone write me a visual basic code that will do the following on a spreadsheet that already has data? A column for "Tube Type" default is SST (this is in a validation list), how can I change the entire spreadsheet to automatically default to from "SST" to "Green" (the word, not the color) rather than SST. So rather than all the columns taht default to SST, I want them to automatically default to Green. I tried everything I can think of but someone said I probably need a visual basic code to do, HELP!! Rhonda Randolph Medical University of South Carolina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I don't want to run visual basic editer code after saving... | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
How do I protect Visual Basic for Application Code | New Users to Excel | |||
Visual Basic code available for all open workbooks | Excel Worksheet Functions | |||
Visual Basic Code Remains in "memory" | Excel Worksheet Functions |