Does anyone know how to insert drop down (check boxes) menus into Microsoft Excel spreadsheets?

Question

Basically I'm trying to make a simple cahrt that works out income so I want somthing that looks like this Check box or drop down enu (Number of hours) times the hourly rate = answers

Could anyone explian how to create this in a form that I could put into an excel spreadsheet?

Answer 1

First you need to type up the different answers to be available in the drop-down menu. The best place to do this is in another sheet.
Select them all then click on 'insert' --> 'name' --> 'define'
Give a name to your list (no spaces allowed) then click on OK.

Then go back to your original sheet and the cell you want the drop-down menu to be in.
Go on 'Data', select 'validation'.
In 'settings', under 'allow' select 'list' then under 'source' type in '=' followed by exact name of your list.

You have now got a drop-down menu on the selected cell.

I hope that helps :-)

Answer 2

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 3

I will be glad to help, I have made these for over 6 years
I can create a VBA macros to do almost anything you want in Excel (Just like an application)

Mail me here in Y! Answers, to see what is what you need


Enjoy my profile, I am the VBAXLMan

Answer 4

Use Visual Basic (VB) toolbox.
Read Help for details. It's a lengthy procedure.

Answer 5

Look Up "Pivot Table"

Answer 6

go to tools ....options......customize....Control toolbox.....then scroll down will have all the options of...

option buttons..toggle button..
text box....list box...combo box....ect