View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geniusideas geniusideas is offline
external usenet poster
 
Posts: 70
Default How to count drawing object (text box) in vba

Hi,

My next project is to count drawing object which is textbox place this
textbox content into cells.
For example:
TextBox1 = My Name
TextBox2 = is
TextBox3 = Micheal Jackson

Final result all these text is inside individual cell
Range(A1) = My Name
Range(A2) = Is
Range(A3) = Micheal Jackson

Please help in vba code.Thanks
Note : number of textbox is umlimited..
Please help