items in drop down lists in excel combo box not showing

Hi,
I've created an excel user form for inserting simple entries into a database. Amongst simple text/data entry, the form incorporates a combo box with a drop down menu of items to select.

The combo box has been created using the following VBA code (as came from the 'Contextures' website):

Please Login or Register  to view this content.

The worksheet where the drop down list is stored is named 'Drop_down_lists'. The range name to incoporate the drop-down menu selections is called "Expense_type" and is defined as the following formula :

=OFFSET(Drop_down_lists!$A$2,0,COUNTA(Drop_down_lists!$A:$A)-1,1)

I've tried putting the range name of 'Expense_type' into the Row source box in the Properties of the Combox in VBA (name CBOexpense), but still when I run the Macro to display the user form, the drop down box remains blank.

Have I named everything correctly and referred to ranges correctly in the program? I am using Excel 2003.

If the cells are populated with a formula you might try to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

On a side note, please use code tags when posting code. To use code tags highlight your code and press the # in the toolbar.

Can you attach your workbook as an example?

To edit your first post:

Click 'Edit Post' below your first post. Highlight the code and press the # in the toolbar. Then click 'Save'.

try:

Please Login or Register  to view this content.

This is untested. There was an 'Permission Denied' error when I tried to open your userform.