View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] willjohnson33@yahoo.com is offline
external usenet poster
 
Posts: 15
Default Format for underlining a cell

Thanks Gary's Student. I see what you are doing, but now my question
is: Is there a way to code it in VBA so that it automatically adjusts
the spaces to the width of the column? I'm assuming that there is some
ratio of characters per column width but I am just curious how to do it
in VBA. I basically am just creating an underline toggle that scrolls
through a few different options as far as color/thikness etc...


Thanks