If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
combo box
Hi,
how can I put combo box on sheet from which user can pick appropirate month? Thanx alekm |
#2
|
|||
|
|||
combo box
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 |
#3
|
|||
|
|||
combo box
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 |
#4
|
|||
|
|||
combo box
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 |
#5
|
|||
|
|||
combo box
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filtering records using multiple combo boxes | Mark Senibaldi | Using Forms | 0 | June 17th, 2004 03:55 PM |
Cascading Combo Boxes | Tom | Using Forms | 1 | June 9th, 2004 02:04 AM |
Cascading Combo Boxes | Tom | Using Forms | 0 | June 8th, 2004 09:24 PM |
Combo Box Problem | Charles | Using Forms | 0 | May 28th, 2004 09:15 PM |
Multiple combo boxes | Lee | Worksheet Functions | 2 | May 6th, 2004 02:49 PM |