View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
weh3[_2_] weh3[_2_] is offline
external usenet poster
 
Posts: 1
Default Comment Box Sizing

Have worksheet in which data entry is driven by userform
selections. A couple of forms have triggers that auto
generate and insert comments into various cells of the
worksheet. I am trying to come up with code that will
format ALL comments to the same ScaleWidth and
ScaleHeight either as they are created OR globally as a
default size defined by me.

Anyone have an idea of how best to handle this, or do I
seek the "impossible". Much thanks for any help.