+ Reply to Thread
Results 1 to 4 of 4

user form initiailising incorrectly

  1. #1
    Registered User
    Join Date
    05-23-2012
    Location
    Eastbourne England
    MS-Off Ver
    Excel 2003
    Posts
    5

    user form initiailising incorrectly

    Hi

    I have a user form that is used to input data from feedback forms. This is pre-populated with set answers from a drop down list eg question 1 score yourself 1,2, 3 or 4 or question 2 the answer is either yes or no y or n

    There are several pages and at the end teher is a save button that saves the responses into a spreadsheet and then restarts the form back at the first page.

    When the form is opened initially by the command button the drop down lists are populated correctly.

    However when the save button is used, the first page has the drop down lists duplicated. eg 1,2,3,4,1,2,3,4,. y,n,y,n,

    This does tend to create errors when you try to tab through the form.

    Any ideas what programming is creating the duplicate drop down list?

    The attached document has screen shots and the programming from VB

    The save button is Command button 16

    Thanks in advance

    James
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,833

    Re: user form initiailising incorrectly

    What's the purpose of posting pictures of forms and copies of Excel macros as text in a Word document?
    Why did you not post the Excel workbook instead?
    No one is going to try to recreate and troubleshoot it for you.
    Ben Van Johnson

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: user form initiailising incorrectly

    I'd guess you are running code that uses additem to populate the controls but you are not clearing the control first. add a combobox1.clear for example at the start of the code.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    05-23-2012
    Location
    Eastbourne England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: user form initiailising incorrectly

    Joseph thanks that has worked fine.

    Protonleah - i couldn't attach the file as it was too large!

    Thanks

+ 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