 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I've not used excel for a few years and now I have a shiny new work lap top I have to re-acquaint myself.
I'm making a spreadhseet to track my leads/projects etc.
I'm aiming to have an option of having a drop down list in one of the cells with an option to choose one of nine possible outcomes.
how the **** do I do it??!!
Either:
a) Select the cells you want to limit to the choice list, go to Data>Validation, select Allow: List, and in the Source box below type your list of nine choices separated by a ","
for One Point. or...
b) Put your list of nine options somewhere on the sheet you are going to be selecting them in, Select the cells you want to limit to the choice list and go to Data>Validation, select Allow: List, and in the Source box below select the Array of nine cells that form you list.
for 2 points... or
c) Put your list of nine options anywhere in the workbook (any sheet) and select the list of nine choices (and maybe a few spare beneath the list) and got to >Insert>Name>Define> and give your selection a name and click "Add". Now Select the cells you want to limit to the choice list go to Data>Validation, select Allow: List, and in the Source box below type "=TheNameYouGaveYourRangeOfChoices".
For 3 points!
This is for Office 2003. For 2007 in c) go to >Formula>Define Name and follow the same instructions.
Dont forget you can copy and paste special "Validation" to apply the same validation to other cells quickly.
and for lots of points, create a userform and a VBA script so that you never actually enter anything into a spreadsheet but rather a nice frontpage.
and for lots of points DEDUCTED, create a userform and a VBA script so that you never actually enter anything into a spreadsheet but rather a nice frontpage.
heathen. 🙄
and for lots of points, create a userform and a VBA script so that you never actually enter anything into a spreadsheet but rather a nice frontpage.
+1
I'm pretty much 100% VBA now and just use WSs to store the raw data.
Stoner: you stick with Excel. I can follow and understand your examples 😀
VBA answers are just knobbers, the poster is looking for some simple advice and you have to post that. Pair of male chickens.