Entering Values into Combobox in Spreadsheet
 

I'm trying to place a combobox on a spreadsheet and then enter values
into it manually for the user to choose (specifically the months in a
year). I'm been through the forums and found instructions to go to
format control and properties and add it there. However, the only
option available to me in properties is object positioning. There is
nothing there about adding values. The only other way I can think it
would be possible is to add it to code which runs when the workbook
opens (an example would be helpful) but if there is a simplier way, I'd
much rather use it.

Thanks

Reg

Entering Values into Combobox in Spreadsheet
 

You need to right click and go to properties instead of Format control.

In the properties of the combobox. you will find Listfillrange field.

add the values in particular cells of hte sheet. and then point the
listfillrange field to those cells. (E.g.if you type in your months Jan ,
feb, march,etc in Cell A10 to A15, thent ype the listfillrange A10:A15

hope this helps


"Regnab" wrote:

I'm trying to place a combobox on a spreadsheet and then enter values
into it manually for the user to choose (specifically the months in a
year). I'm been through the forums and found instructions to go to
format control and properties and add it there. However, the only
option available to me in properties is object positioning. There is
nothing there about adding values. The only other way I can think it
would be possible is to add it to code which runs when the workbook
opens (an example would be helpful) but if there is a simplier way, I'd
much rather use it.

Thanks

Reg

Entering Values into Combobox in Spreadsheet
 

Flow,

Works a treat - thank you. Was wondering through, is there anyway I can
enter the values straight into the properties like one can use Row
Source in access??

Cheers

Reg