combo box

[Guest]

Hi,
how can I put combo box on sheet from which user can pick appropirate month?
Thanx
alekm

 

[JulieD]

Hi alekm

IMHO the easiest way to achieve this is to click in a cell and choose Data /
Validation from the menu, then under the settings tab and the box called
"allow" choose list, in the white line at the bottom of the screen type your
months separated by a comma (,) and then click ok

let us know how you get on
cheers
julieD

 

[JulieD]

Hi alekm

i thing it's a regional settings / international settings thing - there's
people on here who would know more about the reason behind it - hopefully
one will post here.

Cheers
JulieD

Thanx, it helped.
I'm generally confused when to use ',' and when ';'. Your suggestion

worked only when I put ';' . I've found number of examples when even help in
Office suggests one but another choice works.

 

[Dave Peterson]

I toyed with:

Windows start button|Settings|control panel|regional settings applet
Number tab|List separator

And could duplicate your suspicions!