Combo box results also displaying in another sheet RRS feed

  • Question

  • Hi there!
    I had two sheets(Sheet1 & Sheet2 -both macro enabled). I am using a combo box with VBA code enabled. 

    Problem: Combo box results are displaying over other sheets. When I go back to sheet where combo box is there and try to select a drop down item, Excel crashes. Not sure where the issue is.

    Help me out of this problem.

    Thanks in advance!!
    Monday, June 15, 2020 12:52 AM

All replies

  • I am assuming that the ComboBoxes are on a worksheet. Is this assumption correct?

    Are you referencing ranges in VBA code without specifying the worksheet? If the worksheet is not specified with the range then Excel assumes the ActiveSheet.

    In the Properties, the ListFillRange and LinkedCell also must include the sheet reference with the range like the following screen shot.

    Regards, OssieMac

    Tuesday, June 16, 2020 3:58 AM