chem101
10-19-2010, 05:39 AM
Hello Everyone,
I need your help. I'm able to import a .jpeg picture into a spreadsheet. I can then copy it to another spreadsheet in the same workbook. I can do both using VBA code. The problem I'm having is using code to clear the picture on the user form. This is what I've tried so far:
Sub ClearInputs()
With wksNewOrder
.Range("i33:aa44").ClearContents
End With
End Sub
I've also tried:
Sub NewOrderClearInputs()
Application.ScreenUpdating = False
Range("c8:c8").Select
Selection.ClearContents
End Sub
I feel like there's a simple solution that I'm just not seeing. I don't think I'm calling out the pic correctly in the code.
Any assistance you can provide will be greatly appreciated!
Thank you!
I need your help. I'm able to import a .jpeg picture into a spreadsheet. I can then copy it to another spreadsheet in the same workbook. I can do both using VBA code. The problem I'm having is using code to clear the picture on the user form. This is what I've tried so far:
Sub ClearInputs()
With wksNewOrder
.Range("i33:aa44").ClearContents
End With
End Sub
I've also tried:
Sub NewOrderClearInputs()
Application.ScreenUpdating = False
Range("c8:c8").Select
Selection.ClearContents
End Sub
I feel like there's a simple solution that I'm just not seeing. I don't think I'm calling out the pic correctly in the code.
Any assistance you can provide will be greatly appreciated!
Thank you!