Runtime Error 1004 when trying to use a drop down box (data entry form)

[NickyPrim]

Hi guys,

This is my first post on the forum, so I'd just like to say hi to everyone and thanks for having me, and thanks in advance to anyone who would like to help me.

My friend has created a custom data entry form on Excel (I currently have an Office 365 sub and version 15.38 on my Mac OS High Sierra) however I am encountering issues when trying to select from a drop down box. The list doesn't appear and sometimes when I try to make a selection and add it, I get a VBA Runtime 1004 error.

She has tested the data entry form on two other MACs and it works fine, so I am totally clueless as to why I am having issues on my machine. Does anyone have any ideas? Thank you.

Cheers everyone,
Nicky

[NickyPrim]

Here is a screenshot attached of the debug code

Here is the code relating to this function:

Please Login or Register  to view this content.

[xlnitwit]

Hi,

If there's no data below A1 on the sheet, you would get that error because you are trying to refer to a cell below the last one on the sheet. Using End(xlDown) is rarely a good idea- it is better to start from the bottom and work up.