Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

For John D Additional work on Insert Picture that you completed…

Customer Question
For John D: Additional work on...
For John D:

Additional work on Insert Picture that you completed for me yesterday.

1) It needs an error routine if user cancels the file load that gracefully exits .... Resize rowheight needs to be either reset or the code moved to after the file is obtained.
2) I would also like an "on event" for a mouse rollover that increases the picture size when the pointer is in the picture cell.
Submitted: 8 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 8 minutes by:
6/20/2010
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
Experience: Vast experience in Excel programming and business solutions
Verified

Hi Jim,

 

Just letting you know that I will look into this later today. Will get back to with the solution, or if I need any clarification.

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
OK. Cool
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Ok, did the first two, but I was not able to understand how exactly you want the picture resizing to work.

 

First you need to click on something to invoke an event which will fire the macro. Now of course we cannot have a code assigned to a picture object if the picture has not been loaded yet. So your option for triggering the macro is selecting or clicking the cell itself, or by using a button

 

The other thing that is not clear is if you want the macro to resize the picture you need to input the desired dimensions. Would that be entered in an Input box?

 

In the meantime here is the modified macro for the first two.

 

http://www.sendspace.com/file/ucide9

 

Ask Your Own Programming Question
Customer reply replied 8 years ago

Hi John,

 

How about a separate macro that toggles between the cell-sized picture and the larger size. I want to set the size programmatically and not let the user change it.

 

If Pic exists then enlarge //// If Pic exists then restore to cell size.

 

Show me two options... mouse over and single click...

 

Okay?

I have another question if you want it. It will relate to the numbering levels to assist me in assigning formats.. I have over 5,000 lines of data to format. Let me know and I'll file another question with JA

 

Jim

Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Ok, I will see what I can come up with

 

You can post the new question as a separate question or just post it here if you want.

 

 

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
I already posted it. For John D:
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Jim,

 

I am not sure what sizes you want to toggle between, but sizing pictures is not as easy as it sounds because one has to consider among other things the aspect ratio of the picture which will make it fit in one dimension only. It also depends on the sizes of your own pictures, and it also may require some trial-and-error procedures to arrive at a desirable result.

 

In the file below this is how I envisaged the sizes - i.e. based on which cell is selected. If you want it differently feel free to play around with the code (depends on personal preference and can a bit time consuming)

 

http://www.sendspace.com/file/lw064b

 

Hope this helps.

 

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask John D Your Own Question
John D
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Vast experience in Excel programming and business solutions

John D is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I am looking for a macro that will add a picture (.jpeg) into
I am looking for a macro that will add a picture (.jpeg) into cell A2, based on the name in cell A1. Pictures are stored in a folder named "Pics" on my C drive. I am very much a novice in macros. I ha… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
For John D, Hello John, I wish on input sheet to have a button
For John D, Hello John, I wish on input sheet to have a button which says "STEEL PURLINS" on press this buttom the message will say "Before inputing Steel Purlins have you finished inputing all other … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I need a code to format all my pictures and set it at an
I need a code to format all my pictures and set it at an absolute position. I have attached the format i want. I need it urgently so i would appreciate if you guys could code it for me.… read more
technicalcat
technicalcat
Computer Science
840 satisfied customers
Can I resize an image with css or php, while maintaining ratio
Can I resize an image with css or php, while maintaining ratio and controlling file size? I have a series of large images, and I cannot have a page loading slowly.… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,131 satisfied customers
I would like a print button within a lightbox... I can not
I would like a print button within a lightbox... I can not get it to work since the lightbox is shown when the user clicks on one of the image rollovers on the site. How can I get this to work? Here i… read more
Ruben G.
Ruben G.
Vocational, Technical or Trade Scho
69 satisfied customers
i would like a macro that will copy a picture from a particular
i would like a macro that will copy a picture from a particular cell range in 1-worksheet and paste into other worksheets in a particular cell range. i tried with a simple record macro. but this only … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
how to enter data then move automatically to new work sheet
how to enter data then move automatically to new work sheet once certain criteria is met whilst forcing certain cells to be completed… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Hello; I would like to bring to my Excel worksheet 4 different picture
Hello; I would like to bring to my Excel worksheet 4 different pictures, depends on the results of another input that will be on cell B2 in that worksheet. If this cell has "1" picture #1 will be show… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
John; I need some data validation code for VBA 2007. For
John; I need some data validation code for VBA 2007. For Cells Range (O2:O20) restrict user choices to (REL,N/A, X or "") where "" means cleared cell or no data. For Cells Range (P2:P20) restrict user… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Excel 2007 how do you insert a picture into a cell so when
Excel 2007: how do you insert a picture into a cell so when you sort the worksheet the pictures move with the data… read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
In VB 6 I need to display a .BMP file and be able to resize
In VB 6 I need to display a .BMP file and be able to resize without distording or pixilating the image. Could you please show me how to do this.… read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
I want to insert a picture from file, after entering the file
I want to insert a picture from file, after entering the file name into another cell. Example: I enter the word DOG in cell A1, and in cell B1 the picture with filename DOG.JPEG is inserted from the p… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Im a struggling beginning using macros that Ive written with
I'm a struggling beginning using macros that I've written with some assistance. I need some to review the code. If error trapping, DIM statements, etc. are needed, I would like you to do them. Please … read more
Bill Sprouse
Bill Sprouse
Bachelor\u0027s Degree
37 satisfied customers
Need a Macro to 1.It must allow user to select a cell on
Need a Macro to: 1.It must allow user to select a cell on the worksheet 2.Resize the RowHeight to 86.25 3.Allow user to browse and select a picture (*.jpg) to insert 4.Insert it in the ActiveCell. [NO… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Hello, I want to get a pop up message in excel when a condition
Hello, I want to get a pop up message in excel when a condition is TRUE. I am bringing in live data and want to notified through pop up when the number in the cell is less than or greater than a speci… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I am writing an application in visual basic for ms excel 2003.
I am writing an application in visual basic for ms excel 2003. In the application forms I have textboxes within frames. I need to validate textbox entries upon exiting (i.e., tabbing out) the frames. … read more
Karl Everest King
Karl Everest King
Web Designer, Programmer
Vocational, Technical or Trade Scho
224 satisfied customers
Hi John, Iain again! I think my problem may be the Functions! They
Hi John, Iain again! I think my problem may be the Functions! They use the ActiveCell which may not be the Changed Cell if the user hits enter! The code you gave works fine but when i change a cell to… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Question for John D On a user form(uf1) is a text box (tb1)in
Question for John D : On a user form(uf1) is a text box (tb1)in which the user is to type a string, on the EXIT event of (tb1) the code is to compare this string against a list on a worksheet(ws1).ran… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x