Combobox value defines Combobox Rowsource

The code works fine apart from this part which causes an error because there is no sheet called 'DateSheet - Fitness'.

Please Login or Register  to view this content.

try using a range name and set it as follows

Please Login or Register  to view this content.

Same code causing the problem but different error for a different reason.

The reason this time is that 'DataSheet - Fitness' is completely blank so LR can't be found.

Which userform is causing the error and what's the error message?

When I try and show UserForm1 I get an 'object required' error here.

Please Login or Register  to view this content.

I can't find anything called LookupLists.

By the way, if you add this (which you should have in all modules anyway) at the top of the module,

Please Login or Register  to view this content.

there are LookupLists is highlighted again as are various other undeclared variables.

I get the error on the same line as you do but when I add Option Explicit, then goto Debug>Compile... I get the same error 3 times here.

Please Login or Register  to view this content.

The reason is you don't have sheet with the code name LookupLists, that's one of the sheets tab name.

Try replacing LookupLists with Worksheets("LookupLists").

I also get errors wherever dteDateSelected, ctrl or FirstRowAdd appear.

PS If want to prevent these types of errors try adding Option Expicit to every module.

You can actually make that happen automatically if you goto Tools>Options... and check Require variable declaration on the Editor tab.

That's becuase you've set the RowSource property of the combobox cbxTypeEncounter.

You can't use RowSource and then try to populate using List it's one or the other preferably the latter.

It forces you to declare variables.

Which is a good thing as it can help you find typos, misspelling, undeclared variables...