Mourning the loss of our friend, WhitPhil.
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
 
Business Applications
Tag Cloud
access audio black screen blue screen boot bsod connection crash dell desktop driver drivers dvd email error excel firefox hard drive hardware hijackthis internet keyboard laptop malware monitor motherboard network networking outlook problem ram recovery router safe mode screen slow sound spyware tdlwsp.dll trojan upgrade video virus vista vundo windows windows 7 windows vista windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Excel Userform - Image field which loads to worksheet

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

 
Thread Tools
7020northgreen's Avatar
Computer Specs
Junior Member with 1 posts.
 
Join Date: Nov 2009
Experience: Beginner
07-Nov-2009, 09: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 Bookmark and Share

Smart Search

Find your solution!



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


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 11:46 PM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
Powered by Cermak Technologies, Inc.