+ Reply to Thread
Results 1 to 4 of 4

Sources of help Excel2007

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Sources of help Excel2007

    Dear Forum Members,
    I am currently working at the limit of my knowledge, and I am frequently frustrated by my inability to find quick answers to what seem to me simple questions.
    For instance I want to use a structure such as this
    Please Login or Register  to view this content.
    Where can I find the properties/methods possible for UserForm1.Controls ?
    if I press F1 a blank help form comes up. If I type UserForm.Control in the search box I get a message telling me there is no information. If I right click on the word control in the code editing screen a huge list of words appears, none of which seem relevent. All I have found so far is that UserForm1.Controls.Name is not accepted.
    I know that if I ask this forum for specific help I will get it, but how much better it would be if the various help schemes within Excel and VBA could actualy be used.

    I know that this posting is a bit of a rant, I am sorry about that, but I suspect that a good clear answer would help lots of people.
    John

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,438

    Re: Sources of help Excel2007

    This code would give you better intellisense prompts.

    Please Login or Register  to view this content.
    I searched for 'control collection' via the help dialog.
    You may find better results if you restrict help to using stuff on your pc rather than searching office online.

    The object browser (F2) will also provide more details of properties and methods available.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Sources of help Excel2007

    try this code
    Dim ctrl as Control
    For each ctrl in UserForm1.controls
    Find Name
    If ctrl.name="textbox1" then _____
    Next ctrl

  4. #4
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Sources of help Excel2007

    Andy and Sadath31
    Thanks for your input. I will take your ideas home and play with them tonight.I,ll come back to you tomorrow if I am still stuck. I didn't know about F2 Andy so many thanks for that.
    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1