I would like to create a single receipt of payment document for each of the services my company offers.
I would like the receipt document to contain a drop-down box listing all our services to be chosen from whenever the document has to be issued for our customers.
Is it possible to add such a drop down box in my document (and print without showing the drop down box)? If so how?
Perfect answer, thank you.
If I understand your request correctly, create a list of your “services” you want in the dropdown. Put one entry per cell and only use one column. It can be on the same sheet in a different area or in another sheet. Next go to Data/Validity. Under the Criteria tab, in the Allow dropdown choose Cell Range. In the Source box that appears select the range of your list you created. Make sure you only select the column the list is in. You can select extra empty cells at the bottom to leave room for expansion. Now go back to the cell or range of cells you formatted with the data validity and fill the rest of cells you want a dropdown in. Click the cell and a dropdown box will appear with the contents of your list. If you want to do more with the results you can add formula’s that will pull in pricing, model numbers, etc. The dropdown arrow/box will not print. I use this all the time and it works very well. Let me know if you need anymore help. Sorry for the long-winded reply.
You can do this with Form Controls:
View > Toolbars > Form Controls
I can drag and drop the listbox into the text, but how can I actually use it? When I click on it, all I get is a move cursor, I don’t actually get the opportunity to use the listbox.
