Inserting image in a particular cell in VBA [Solved/Closed]
adikademani -
Nov 1, 2016 at 08:52 AM - Latest reply: AdiK - Nov 9, 2016 at 02:44 PM
Related:
- Excel vba insert picture into cell
- Insert picture in excel cell with vba - Best answers
- How To Insert Pictures in Excel Using a Macro - How-To - Excel
- Excel vba insert picture based on cell value ✓ - Forum - Excel
- Insert/Remove photos depending up on ref. cell value changing ✓ - Forum - Excel
- Excel vba insert value into cell - How-To - Excel
- Excel vba insert picture from folder - Forum - Excel
6 replies
- Posts
- 2448
- Registration date
- Sunday September 12, 2010
- Status
- Posts
- 2448
- Registration date
- Sunday September 12, 2010
- Status
There must be some misunderstanding, because the code you posted does that. Where does the picture go if not Q1?
- Posts
- 2448
- Registration date
- Sunday September 12, 2010
- Status
Hi Trowa,
Thanks a lott, the issue is solved.
I need some more help with the following. I am trying to insert an image into a particular cell by calling the value stored in the variable via an InputBox. The following code is showing error. Kindly help me. Thank u :)
Sub image()
Dim x As String
x = InputBox("insert image name")
Range("E5").Select
ActiveSheet.Pictures.Insert( _
"G:\PEP\04.Kaizen\KAIZEN Audit\02 Auditfragebögen\5S questionaire\ x "). _
Select
End Sub
Thanks a lott, the issue is solved.
I need some more help with the following. I am trying to insert an image into a particular cell by calling the value stored in the variable via an InputBox. The following code is showing error. Kindly help me. Thank u :)
Sub image()
Dim x As String
x = InputBox("insert image name")
Range("E5").Select
ActiveSheet.Pictures.Insert( _
"G:\PEP\04.Kaizen\KAIZEN Audit\02 Auditfragebögen\5S questionaire\ x "). _
Select
End Sub
- Posts
- 2448
- Registration date
- Sunday September 12, 2010
- Status
Hi Adikademani,
You included the x within the path string. Since it is a variable you need to place it outside like:
"G:\PEP\04.Kaizen\KAIZEN Audit\02 Auditfragebögen\5S questionaire\" & x)
Also make sure that you enter the full file name (so with extention) when prompted by the inputbox for the code you created.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
You included the x within the path string. Since it is a variable you need to place it outside like:
"G:\PEP\04.Kaizen\KAIZEN Audit\02 Auditfragebögen\5S questionaire\" & x)
Also make sure that you enter the full file name (so with extention) when prompted by the inputbox for the code you created.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.