+ Reply to Thread
Results 1 to 5 of 5

Combox userform and excel

  1. #1
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Thumbs up Combox userform and excel

    Dears,

    I have two combo box one from user form and another from excel sheet. I want to know if i select item from combo box in user also change combo box item in excel sheet.

  2. #2
    Registered User
    Join Date
    04-10-2012
    Location
    Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Combox userform and excel

    what do you mean by change it.change the selected item on the excel sheet combo box?
    Are the items in each box the same and in the same order?

  3. #3
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Combox userform and excel

    I insert one combo box in excel sheet and i create user form in vba developer and added one combo box. What i mean is if I select list from combo box in user form it automatically affect combo box in excel sheet.

  4. #4
    Registered User
    Join Date
    04-10-2012
    Location
    Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Combox userform and excel

    You could code the change event for the userfrom combo box to update the control on the spreadsheet. If the .ListIndex numbers were the same it shouldn't be too much of a hassle. The event would fire every time you changed the value of the control on the userform thus updating the worksheet combobox.

  5. #5
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Combox userform and excel

    Can you give me an example excel file with attachment.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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