Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    User form in Excel? (2000)

    Hi,
    Is it possible to create a user form in excel similar to what you can in word?
    I've had a quick look round and cannot find it....................
    I have a worksheet that is in a table type format. Its a bit messy but its format cannot be changed. However I thought if the user could have a form where the selections where clearer, this would tidy up the worksheet.
    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User form in Excel? (2000)

    Just like in Word, you can create a userform by activating the Visual Basic Editor (Alt+F11), and selecting Insert | UserForm. Or do you mean something else?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User form in Excel? (2000)

    Sorry, Monday morning moment.................yes I had forgotten to go into Visual Basic Editor. I presume it works by cell reference as opposed to bookmarks.
    I presume I can glean information from another hidden worksheet for comboboxes, etc, within the user form.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User form in Excel? (2000)

    You can refer to cells on a userform:

    - Text boxes, combo boxes, check boxes etc. have a ControlSource property. This is the address of the cell that will contain the value of the control. For example: Sheet1!B37
    - Combo boxes and list boxes also have a RowSource property. This is the address of the range used to populate the list. For example: Sheet2!B2:B23

Posting Permissions

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