Hi,
Can you provide an example (if possible) of usage of Private Type of the
following structu

CarModel as String
CarRego as String
CarYearOfMfg as Integer
CarMilage as Double
CarAlarm As Boolean

In particular, I need to get a grasp how using of Private Type can help
populating UserForm and then sheet cells. Will it be possible with them to
eliminate the need for named ranges? Or the opposite is true?

Hope it's easy to answer :)

Paul