Where do the Wizards go to find this stuff?

[Rocky E]

Where do the Wizards go to find this stuff? Is there a book that tersely lists all the properties of the various Excel objects? For example if I want to control the visible property of a text box named "Text Box 1" what is the correct syntax and constants?

Thanks!

Rocjy

 

[greg0226]

I just went to Barnes and Noble and picked up "Using Excel Visual Basic for Applications" and it is pretty helpful esp. for a beginner like myself. Just an idea.

Greg

 

[bobmc]

My two cents' worth...

This site and those who've made it a practice to help those of us who need a little help and advice have proven invaluable.

Many, many thanks to those of you who know this stuff and provide your insight.

bobmc

 

[Legacy 98055]

Tis not a simplistic approach!

The best way to learn is through application. Books are great and have their use as far as reference, but solving the problem requires diligence and skill.

Helping others here is a great way to learn.
Plus, what you get from a book is what is supposed to work, what you get from here is what actually works. I have tons of books and perhaps they have given me about 10 to 20% of what I have attained so far. I have found the help files better than books in general. You'll stump your growth with that attitude grandpa!
Happy posting!

Tom
This message was edited by TsTom on 2002-03-27 07:50

 

[Rocky E]

Tom,
Well I have no interest in a shooting match or flame fest. Yes I am a Grandfather and proud of it. As a Board Master, your kindness and hospitality encourage me to ask many more questions elsewhere. With your “tons of books” you won’t or can’t offer a title. That seems just a little strange. I have looked at the Object browser and it appears to be handy tool. Thank you for that.

Now just let me go in peace and read a book, please.

Rocky…