PDA

View Full Version : Combo Boxes



spaz9876
11-22-2006, 10:34 AM
I am not very good with VBA. I created a combo box with the form toolbar but it doesnt allow you to change the font and from reviewing many posts, it looks like I need to do a combo box from the control toolbox and use VBA. I have no idea how to do the VBA to list the items I want. I have the list I want included in Range E55 through E83.

Can anyone help me with the code?
I hope the range is all the info you need but if not, let me know.
Thanks!

Ken Puls
11-22-2006, 11:00 AM
No need for VBA if you just want the list.

Go into the properties and enter your range as the ListFillRange. If you want the result put in a cell, fill that cell address into the LinkedCell part.

HTH,

spaz9876
11-22-2006, 03:06 PM
Thank you! That worked great!