Microsoft Excel?

Question

How Do i create drop down list in this Program?


Please help

Answer 1

Start new workbook.

On sheet 2 enter your values in contiguous cells, in one column.

Highlight all the cells you have just entered values into.

Use the Insert | Name | Define Menu/Options or the 'name box' to the left of you function bar and type in a name for list of values you have just typed in. E.g. "Mylist"

Now go to Sheet 1.

If you cannot see the Visual Basic Menu, right click on the tool bar or use the Insert, Toolbars and in each case select Visual Basic.

Now on this tool bar click Design mode, and Toolbox.

Find the Combo Box Tool, in the tool box and click on it.

'Draw' the combo box onto the sheet where you want it.

Now, again in the toolbox, with the Combo Box still selected, find and click the Properties box.

In the properties window, find the ListFillRange property (this appears in the left hand column) In the corresponding right-hand column, type in the name of the name of your list - "Mylist" and click enter.

Now unclick Design mode, and Toolbox and also close the property box by clicking on the 'x' - close window button.

Now click on the Visual Basic Editor buton on the Visual Basic oolbar.

In the Project Window, double click on Sheet 1

In the left hand dropdown of the window just opened, select Combobox1.

Complete the code so it looks like the following:

Private Sub ComboBox1_Change()

Range("A1").Cells.Value = ComboBox1.Text

End Sub


This will put the selected value into Cell A1.


Excel is very powerful, and there are many options, properties and you must be careful when doing the things I have described. I am using Excel 2003, and I know the 'tools' and other items improve slightly as time goes by and new versions are released.

To do this properly, I would get a book on VBA with a focus on VBA for Excel.

Anyway, hope this helps.

Answer 2

Lemme guess, you're in a Computer Literacy class... maybe with the Art Institute??? Because whats funny is that's the EXACT question of this weeks first assignment. weird. "Week 3: Week 3 - W3: Assignment 1 Discussion Discussion Question 3 Compare Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. When should you use each of these applications? When can you use these applications interchangeably? Give examples and reasons to support your answer."

Answer 3

Click on the row with the titles, then go to Data, Filter, AutoFilter.

Answer 4

GoMake sure you have your data and the labels then highlight the top labels then click data-filter-auto filter and the dropdowns will appear.

Answer 5

go to view>toolbars>control toolbox and click the rectangle with the arrow, after that i cant explain even though im good at computers lol (go to help>help index for more)

caarnquist

Answer 6

GO TO bleeping computer . com THEY WILL HELP YOU