Creating a specific EXCEL program.
I am trying to create a simple excel programme, where in one of the cells i will have the options (list of names) to choose from once i clicking once.
I have attached an example of it, under the cell "YES/NO" once u click, a small arrow appears next to the cell, where u can choose either YES or NO from a list.
So i was wondering, if there is any guide i could follow in order to achieve it or if anybody can help me.
I relatively new in EXCEL programming, so i believe that for EXCEL Experts it wont be so difficult.
Thanking you in advance.
Elena
P.S. Dont forget to check the attachment with an example.
| Attachment | Size |
|---|---|
| Excel Example.xls | 98.5 KB |
new to EXCEL programming,
hi Elena.. You need a lot of help here I feel. Your example is really all over the place. Lets take a step back, and I'd like you to summarise what you're actually trying to achieve. The kind of answer I am looking for is a one line response... something like: "I am writing a time sheet entry system" tks Nick
How?
Thank you.
I have managed to do what i wanted.
Found guides on net.
I was wondering, is it possible to delete question since i have managed it?
Thanks,
Elena
Data Validation
Hi,
Can I have all my data in one sheet (exclusively) and use the same in different sheets? I tried, but could not get an answer.
Help me. Thanks
B.W
Data Validation from another sheet
this is possible.
use the INDIRECT function
e.g: =INDIRECT("'My Other Sheet'!$A$15:$A$64")
Nick
Drop-Down List in Excel Cell.
How to add a drop-down list to an Excel cell.
But i want it as follows:
If i try to enter something that isn't in the list, Excel will accept.
Thanks,
Eena
Data validation list
http://www.excelexperts.com/Excel-Tips-Data-Validation-part-1
If you folow the link above you'll find what you need.
To accept values out of the list you need to disable error alerts
Thanks, I have managed to
Thanks,
I have managed to disable error alerts.
???????? ????????)
Dropdown list
comment removed... use Cyril's suggestion.
Suggestion.
Thanks a lot.
What would you suggest?
I need it for the application form.
We are using a lot of names, surnames, etc, therefore in order to avoid mistakes in spelling of this data, i prefer to make drop-down list, so i could choose the ready name out of the list.
Thanks again,
Elena