Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Tag Cloud
access acer asus bios bsod computer crash drive driver drivers error ethernet excel freeze gaming graphics hard drive hardware hdmi internet laptop malware memory monitor motherboard network printer problem ram random registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Excel Userform - Image field which loads to worksheet

Reply  
Thread Tools
7020northgreen's Avatar
Computer Specs
Junior Member with 1 posts.
 
Join Date: Nov 2009
Experience: Beginner
07-Nov-2009, 10:40 PM #1
Unhappy Excel Userform - Image field which loads to worksheet
First of all... I am a total beginner, but think I am 80% done with my goal, but 80 might as well be 0.

I have created a 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. 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.

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.

Thank you for listening,
northgreen
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 04:44 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.