I can't really help you with part 1,but **do you now about auto_size, take a look at it **if you want resize the height of rows 10 to 26 just select them (by: selcting and dragging down the row numbers, OR select you first and Shift select the last row) and when you resize by dragging row border they will all resize. Good Luck !
On Nov 8, 5:44 pm, ellie <elletill...@gmail.com> wrote: > or user prompted for whatever gets the job done...I am just assuming > that would be the way to get it done. > > I have created my first userform to input data into my worksheet. I > have 8 fields which populate my worksheet. On my userform I have an > 'Add Data' button which works like a charm via a tutorial from > contextures.com > > On each row on my worksheet I would like there to be a product image > in the last field. The images are stored in various folders on our > network drive. How do I add an input field on my userform that will > allow the user to point to an image file and in essence be my 9th > field on my worksheet? I have tried creating a button using the > getopenfilename along with other commands for this button but nothing > I have tried comes close to achieving my goal. I am not sure of what > the code should be for that command button anyway...guess that's a big > part of my problem here. Maybe I shouldn't be using a command > button...maybe this cannot be achieved with a userform? > > Can anyone explain to me how I can accomplish this. So, my goal is for > the user to select a photo as one of the fields that will populate my > spreadsheet. Also, if this can be achieved can I set an image size for > this item. Needs to be a little bigger than a thumbnail. > > I have spent hours looking for the answer to this question. I hope > someone has mercy on me. > > ALSO.... > how do I have the rows to a predetermined width and height? I see how > I can set this one by one, but I want the excel spreadsheet to already > have the proper cell sizing before any data is entered. The sizing is > going to revolve around this image that I am trying to get in there. > > ellie -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
