Code Behind Excel's Userform

[manzetti]

Is there anyway to see the userform that excel generates when you select your cell range then select Data --> Form?

 

[manzetti]

More specifically the VB CODE.

Is there anyway to see the userform that excel generates when you select your cell range then select Data --> Form?

 

[mikerickson]

No method that I know of. In fact, I doubt that its written in VBA. What do you want to do with this code?

 

[manzetti]

Replicate it so that I have the same functionality on my form.

No method that I know of. In fact, I doubt that its written in VBA. What do you want to do with this code?

 

[Norie]

I've got to agree with Mike - it's doubtful you'll get the code behind it.

Why not just use it's built-in functionality rather than re-invent the wheel?

If you want something different then you should probably look into userforms.