• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combobox not reflecting values

Piyush_Sanghavi

New Member
I have 4 combobox installed on multiple sheet in a single workbook. same range have been assigned to all 4 combobox.
when i select a value in 1sheet combobox, it does not reflect the same selection on the other sheets. Calculation option is Automatic
 
Last edited:
Hi Piyush ,

Do you mean to say that you have a combobox on each sheet , and there are 4 such comboboxes on 4 sheets ?

If so , each combobox is a separate entity , and the selection made in one will not reflect in the other , even though the ListFillRanges for all the four are the same.

The 4 comboboxes will reflect the same value if all their LinkedCells are pointing to the same worksheet cell reference.

Narayan
 
Back
Top