|
本帖最后由 zglibk 于 2019-9-6 15:22 编辑
老师,请问你段代码要怎么修改才能是原图效果,现在插入的图片被压缩了
谢谢!
- Private Sub CommandButton5_Click()
- Dim rng, wj, i As Integer
- If Len(ComboBox1.Text) = 0 Then MsgBox "请输入订单号!", vbCritical, "提示": Exit Sub
- If Len(ComboBox2.Text) = 0 Then MsgBox "请选择区域!", vbCritical, "提示": Exit Sub
- With Application.FileDialog(msoFileDialogFilePicker)
- .Title = "选择图片"
- '默认打开的文件对话框路径
- '.InitialFileName = "d:"
- If .Show Then
- '获取到路径
- wj = .SelectedItems(1)
- End If
- End With
-
- i = Sheets("销售记录").Cells(Rows.Count, 1).End(3).row
- Set rng = Cells(i, 8)
- ActiveSheet.Shapes.AddPicture(wj, True, True, rng.Left, rng.Top, rng.Width, rng.Height).Placement = xlMoveAndSize
- End Sub
复制代码
|
|