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.
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.
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?
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.
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.
Can you give me an example excel file with attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks