combo box

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

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

"alekm" wrote in message
...
Hi,
how can I put combo box on sheet from which user can pick appropirate
month?
Thanx
alekm

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.
Thanx again
alekm

"JulieD" wrote:

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

"alekm" wrote in message
...
Hi,
how can I put combo box on sheet from which user can pick appropirate
month?
Thanx
alekm

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

"alekm" wrote in message
...
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.
Thanx again
alekm

"JulieD" wrote:

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

"alekm" wrote in message
...
Hi,
how can I put combo box on sheet from which user can pick appropirate
month?
Thanx
alekm

I toyed with:

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

And could duplicate your suspicions!



JulieD wrote:

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

"alekm" wrote in message
...
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.
Thanx again
alekm

"JulieD" wrote:

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

"alekm" wrote in message
...
Hi,
how can I put combo box on sheet from which user can pick appropirate
month?
Thanx
alekm




--

Dave Peterson