Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Methods and/or Properties

Status
Not open for further replies.

LuAlPa

IS-IT--Management
Aug 17, 2006
18
US
Is there a simple way to display all supported methods and/or properties for elements like activesheet or activecell or whatever? The compiler shows them but shows EVERYTHING regardless of the element we are currently dealing with. Or am I wrong?
Sorry for the lack of formal use of terminology since I have never taken formal VBA training
 
Thank you, Ettiene, but regardless of where the cursor is at (in the code screen) I get no response. The hourglass blinks and dissapears going back to the I beam. It is MS VB 6.5 with Excel 2003 SP3
 




If you're using VB, not VBA, then you ought to be posting in Forum222.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
No, I am using VBA. That is the infor I get from the About ... menu in the VBE
 

You should be able to press F2 to bring up the object browser, and if this does not work then you should be able to find it on the toolbar (next to the properties window)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top