Related:
- Vba insert image into cell
- Excel vba insert image into cell - Best answers
- Vba insert picture into cell - Best answers
- Excel vba insert image into cell - How-To - Excel
- Insert picture in Excel macro which takes the file name refrence - Forum - Excel
- VBA code for Inserting an Image - Forum - Excel
- Excel vba insert value into cell - How-To - Excel
- Excel vba insert filename into cell - How-To - Excel
3 replies
TrowaD
- Posts
- 2667
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 13, 2020
Hi adikademani,
To place the image in the active cell instead of Q1 then replace:
Range("Q1").Activate
By:
ActiveCell.Activate
Best regards,
Trowa
To place the image in the active cell instead of Q1 then replace:
Range("Q1").Activate
By:
ActiveCell.Activate
Best regards,
Trowa
adikademani
Hi Trowa,
thanks for the quick reply, but the image is still not getting inserted into that particular cell. For example, how do i insert a picture into the Cell Q1 ?
thanks for the quick reply, but the image is still not getting inserted into that particular cell. For example, how do i insert a picture into the Cell Q1 ?
adikademani
>
TrowaD
- Posts
- 2667
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 13, 2020
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
TrowaD
- Posts
- 2667
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 13, 2020
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.
