Can anyone help me with VBA in Excel please.

I want the user to be able to select a directory where files are to be saved, or add a new directory which is then created. I have looked at the Common Dialog Control but it is not suitable as it selects a file. Is there anything similar for directories or can someone suggest another method.

As I am a novice, sample code would be much appreciated.

Thanks