How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Need help with making a button that would add a picture in a

Customer Question

Need help with making a button that would add a picture in a specific cell that would fit using vba and macro. Running office 2010. I have tried multiple codes I found online but can't get any of them to work.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 1 year ago.

can you send an example?

Customer: replied 1 year ago.
of the form I'm working on???
Expert:  The-PC-Guy replied 1 year ago.

send an example of what you are looking to do.

Customer: replied 1 year ago.
here is a screen shot
Expert:  The-PC-Guy replied 1 year ago.

and where is this picture located?

Customer: replied 1 year ago.
in C:\Library\ Pictures, no specific picture just one in that folder that I could click on and it would insert it into the specific cell
Expert:  The-PC-Guy replied 1 year ago.

i mean does a specific picture get inserted or does a file open box open and someone selects a picture?

Customer: replied 1 year ago.
a file open box open and someone selects a picture of there chose. like in word doc you can add a picture button in a cell, click the button and it would take you to your picture folder, scan for the picture you want then upload it.
Customer: replied 1 year ago.
as you know I would have to open up VBA create the code then make a button and assign a macro to it.
Expert:  The-PC-Guy replied 1 year ago.

I am familiar with VBA.

It is not impossible. And not to complicated.

I can create the code for $120.

Is this something you still want to proceed with?

Customer: replied 1 year ago.
How about $60, and wouldn't you need me to send you the document to ensure it would work?
Expert:  The-PC-Guy replied 1 year ago.

yes, I would need the document.

The price is $120.

Keep in mind the following

1. This is how I make a living.

2. The price also includes troubleshooting, if for some reason you cannot run the macro or you get errors, or it doesn't quite work right.

3. The price was arrived at based on my experience which is extensive, this is why I know enough to recommend a macro instead of a formula, I know how excel works and works best.

but I do understand if you don't want to proceed

Customer: replied 1 year ago.
Understand the above but for now I'll pass thanks.
Expert:  The-PC-Guy replied 1 year ago.

ok, that is fine.

If you change your mind, you can come back here and let me know

Customer: replied 1 year ago.
Will do
Expert:  The-PC-Guy replied 1 year ago.

have a good night