Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box
Hi,
I have made an Invoice in Excel, and I would like to make this file easier for using, for example, choosing the name of company, services, and other items using combo box, ..my idea was not using much VBA code, but using Excel formulas. Anyway, is it possible someone to send me a simple example, or maybe useful links where I can learn more about using forms in Excel. Th in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box
Emilija;
Use Data Validation. You can let users choose what input they may have by selecting a range of cells by applying data validation to that range of cells. In the menu choose : Data | Validation In the dialogbox that is shown you can select all of your needs to do so. Choose "List" in the Validation Criteria under the Allow label. In that case is it handy if you create a list of services on another worksheet. Give that list a name (Services for instance) and refer to that name. Succes; Mark. More Excel ? www.rosenkrantz.nl or --------------------------------------------------------------------- "emilija" wrote in message ... Hi, I have made an Invoice in Excel, and I would like to make this file easier for using, for example, choosing the name of company, services, and other items using combo box, ..my idea was not using much VBA code, but using Excel formulas. Anyway, is it possible someone to send me a simple example, or maybe useful links where I can learn more about using forms in Excel. Th in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box
Tx, but my idea was, no to limited users what to choose, but gave him an
opportunities, to choose (by selecting, and confirming with enter or something) an item from some list let say entered on some other place Emilija "Mark Rosenkrantz" wrote in message ... Emilija; Use Data Validation. You can let users choose what input they may have by selecting a range of cells by applying data validation to that range of cells. In the menu choose : Data | Validation In the dialogbox that is shown you can select all of your needs to do so. Choose "List" in the Validation Criteria under the Allow label. In that case is it handy if you create a list of services on another worksheet. Give that list a name (Services for instance) and refer to that name. Succes; Mark. More Excel ? www.rosenkrantz.nl or --------------------------------------------------------------------- "emilija" wrote in message ... Hi, I have made an Invoice in Excel, and I would like to make this file easier for using, for example, choosing the name of company, services, and other items using combo box, ..my idea was not using much VBA code, but using Excel formulas. Anyway, is it possible someone to send me a simple example, or maybe useful links where I can learn more about using forms in Excel. Th in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Can one combo box control the data in a different combo box | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |