auto column width resizing

[misterpogiako]

lets say i type for now...
A1 = USA
B1 = Philippines

and then later
A1 = dog
B1 = cat

is there a way that the width would automatically adjust even as i change the values of the given cells; meaning, if a word is long, the width will automatically adjust "longer", if a word is short, then it will automatically adjust "shorter".
i know how the "AutoFit Column Width" works but i dont want to press that everytime my values change (words becoming shorter or longer). Thanks

[Olly]

Put this code in the worksheet module:

Please Login or Register  to view this content.

Edited to be simpler!

[misterpogiako]

i went to VBA but i dont see a worksheet module. im only seeing "Sheet1 (Sheet1)" & "ThisWorkbook" or maybe im only already looking at it? sorry, im a beginner here esp with vba stuff.

[misterpogiako]

GOT IT! it worked. i pasted the code in Sheet1 (Sheet1). its now automated THE only thing is the if i want to undo something it wont work. running macros i guess kills the undo switch. the undo can be incorporated in the code but i guess that would be too much a burden; that would be going too deep as mentioned here http://www.excelforum.com/excel-prog...o-running.html

[Olly]

Well done for figuring out where to put it. Glad it's working for you.

And good for you for searching the Undo problem.