View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_6_] kirkm[_6_] is offline
external usenet poster
 
Posts: 156
Default Adding a Value List to Combo Box

I thought this would be easy!

My instructions are

Set the Row source Type property to Value List

0n the Data tab of the property sheet,
click .... to open the Edit List Items
dialog box, and then type the items on
separate lnes.

However I have no such Selection available in RowSource.

Another instruction says


The combo and list box controls allow you to enter a list of items.
When you choose this route, you enter in the control's Row Source
property a setting in the form of

"item1";"item2";"item3"

But if I enter that into RowSource, Excel tells me

Could not set the RowSource property. Invalid property value.

Very frustrating! Anyone know why this isn't working?

Thanks - Kirk