Formatting User form display same as appearing on sheet cells

[nagovind]

Dear all,

Kindly advise how to make the display in the user form in the format as same in the sheet cells

Required is SIZE of the cells/ gap shall be same not even the colours

Need to have same ROW size while appearing in the user form.

Thanks

 

[Monty]

Hello..

This can be easily done by converting as sheet range as an image to display on user form with image embedded...

 

[nagovind]

@Monty
Thanks for your reply.
I will try if it is possible to DELETE the created IMAGE file every time while running this macro

I have 26 sheets
Each sheets needs this action
For each click one image will be created
So need to delete that newly created image every time after closing that display userform

Kindly advise

 

[nagovind]

Yes got it
I will try
thanks

 

[Monty]

@Govind

Excellent...Pls do share the idea n code...It may help somebody...Thanks..

 

[nagovind]

@Monty,

I'm trying my best. Now i'm struck with deleting the picture that is created
I have copied the required display rage and pasted as image file but unable to find it to delete the same
Kindly advise

 

[Monty]

@Govind

Record your macro.

Go to macro recorder ....Select the image and delete...And copy same code in your original to make dynamic.

Hope this helps.

 

[nagovind]

Thank you for your reply.
But i tried already
Each time the image name is different...

 

[Monty]

@Govind

Need store image name in a variable...So that it can dynamically pickup image name and delete