Editing the 'default' userform

[Morphies]

Hi all,

I've recently started playing with userforms.

In a nutshell, the 'default' userform that excel creates for my table is almost perfect. I'd like to add in some combo boxes and entry validation tools.

Is there a way to save the default userform created by excel for editing? seems barmy to have to recreate this to customise it.

Thanks,

Chris

 

[Kyle123]

No, you'll need to recreate it

 

[Morphies]

No, you'll need to recreate it

Hmm, how very annoying.

In that case, is there a way to launch it through VBA? To launch the default userform, not a custom userform.

Thank,

Chris.

 

[Kyle123]

Yes:

ActiveSheet.ShowDataForm