Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Daisy Brown   on Dec 20 In MS Office Category.

  
Question Answered By: Fabian Jones   on Dec 20

debug.print Activesheet.textboxes("Text box  1").top
Activesheet.textboxes("Text Box 1").top=150
Activesheet.textboxes("sausage").top=150
Activesheet.textboxes("sausage").text="sausages'n'mash"
debug.print Activesheet.textboxes("sausages").text

To get an idea of the properties/methods available, while stepping
through (with F8) the vba  you quoted below, stop while in the middle
of the loop and in the immediate pane type:
?tbox.
and when you type the full-stop (period for US residents) you should
get a dropdown list of what's available. Also, in the Locals pane,
you'll be able to look at more info on tbox by expanding its tree.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Textbox - Shape : How to control from vba Or get search suggestion and latest updates.


Tagged: