drop down box

L

litoquez

I am doing this for the first time. I got as far as creating the macro
for a combo box to have it appear on the slide so someone could click
on the drop down arrow and have a list of categories appear from which
they could select one. But when I view the slide the box is empty.
Can anyone walk me through this? Here is my macro:

Private Sub ComboBox1_DropButtonClick()
Sub FillBox()
With Slide6.ComboBox1
End Sub
..AddItem "Information Technology"
..AddItem "Working Capital"
..AddItem "Financial Reporting"
..AddItem "Control & Compliance"
..AddItem "Internal & External Audit"
..AddItem "Forecasting & Budgeting"
..ListIndex = 0
End With
End Sub
 
B

Bill Foley

Well, let's see:

With Slide6.ComboBox1
End Sub
'other stuff here'

Doesn't look like the other stuff (AddItem) will happen!
 
L

litoquez

You're right Bill, my bad on pasting the macro. Excluding the
inadvertent End Sub it still doesn't work for me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Combo Box 10
using combobox for drop down menu? 6
A ComboBox question 6
Combo Boxes 2
What is wrong with drop-down box? 7
VBA Macros 3
How to Add items to a ComboBox list 7

Top