View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Garyw Garyw is offline
external usenet poster
 
Posts: 34
Default Combo Box Anomaly

I've added a combo box to a worksheet with the Input range from
another worksheet Example: GeneralLookups!$B$4:$B$13
Contained in the cells B4:B13 are values 200,300,400/500, etc.
When I select one of the values in the Combo Box it returns line
numbers 1 through 5 instead of the value in the cell.
It seems that it would have to go out of it's way to come up with this.
What's causing this?

Garyw