Re: $$Excel-Macros$$ How to shrink a picture in userform

2012-10-12 Thread David Grugeon
Hillary There was no userform in the file. Perhaps because it was an xlsx not xlsm. In a userform a picture has height and width propertir=es which you can amend in the property sheet or in code Regards David Grugeon On 12 October 2012 19:57, Hilary Lomotey wrote: > Hello Experts > > I'd l

Re: $$Excel-Macros$$ How to shrink a picture in userform * *

2012-10-12 Thread Deba Ranjan
you are welcome !! Thanks & Regards, *Deba ranjan* On Fri, Oct 12, 2012 at 4:21 PM, Hilary Lomotey wrote: > excellent Deba, it works. thanks > > On Fri, Oct 12, 2012 at 10:40 AM, Deba Ranjan wrote: > >> [image: Boxbe] This message is >> eligible for A

Re: $$Excel-Macros$$ How to shrink a picture in userform * *

2012-10-12 Thread Hilary Lomotey
excellent Deba, it works. thanks On Fri, Oct 12, 2012 at 10:40 AM, Deba Ranjan wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (drdeva...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ How to shrink a picture in userform *

2012-10-12 Thread Deba Ranjan
Hi Hilary, After Inserting the Pic in the Userform, you need to go to the properties, and Select the -PictureSizeMode as 1. you can see the pic full. Thanks & Regards, *Deba ranjan * On Fri, Oct 12, 2012 at 4:03 PM, Hilary Lomotey wrote: > i have inserted a picture in a use

Re: $$Excel-Macros$$ How to shrink a picture in userform *

2012-10-12 Thread Hilary Lomotey
i have inserted a picture in a user form in the attached, however, i cant see the whole picture in the userform only a minute portion, i need assistance to shrink the picture in the userform to fit. in the excel sheet itself i placed a picture there to give you an idea of the size that i want it to