How to add more Pattern Style when show xlDialogPatterns

[namngo]

This view is when we show xlDialogPatterns
Application.Dialogs(xlDialogPatterns).Show
How to add more Pattern Style in this build-in Dialog?
Currently, it is fixed with 18 patterns Style. I want to add more like in Pattern Fill that has 48.
Thank you.

 

[plettieri]

hello namngo

I found some info from previous questions


As you noted there are fixed limitations for 18 patterns which is Excel's limits and there appears no direct method to counter or improve on that directly. An option look at might be to create custom user form that copies the xlDialogPatterns, but includes more pattern options. You would then create a Userform in VBA and creating additional patterns.

Hope this helps your design process

plettieri

 

[namngo]

hello namngo

I found some info from previous questions


As you noted there are fixed limitations for 18 patterns which is Excel's limits and there appears no direct method to counter or improve on that directly. An option look at might be to create custom user form that copies the xlDialogPatterns, but includes more pattern options. You would then create a Userform in VBA and creating additional patterns.

Hope this helps your design process

plettieri

If we create Userform and ckpy xlDialogPatterns how could we get the Sample (combination of Pattern and color) and have same behavior as xlDialogPattern?