Hello,
It worked so well last time I had a challenge, so now that I am faced my next challenge I will ask you guys again.
I have a frame with several textbox, dropdowns and optionbutton. Everything does what it is supposed to do, but allthough the controlsource cells are cleared, the old data remains in the Frame. I have found several posts with codes that should do exactly that, but when I try to pair it with my own code it gives error.
Here is the existing code:
Could someone help me adding the additional code that would clear the Frame for old data.
(Extra question: If the Frame is cleared for old data, does that also clear the controlsource cells?)
-B
It worked so well last time I had a challenge, so now that I am faced my next challenge I will ask you guys again.
I have a frame with several textbox, dropdowns and optionbutton. Everything does what it is supposed to do, but allthough the controlsource cells are cleared, the old data remains in the Frame. I have found several posts with codes that should do exactly that, but when I try to pair it with my own code it gives error.
Here is the existing code:
VBA Code:
Sub Save_new_sparepart()
Saverange = Range("a10").Value
'
Range("A1:eek:1").Select
Selection.Copy
Range(Saverange).Select
Selection.PasteSpecial Paste:=xlPasteValues
Range("a6").Select
Selection.Copy
Range("a5").Select
Selection.PasteSpecial Paste:=xlPasteValues
Range("b3:eek:3").Select
Selection.Clear
Range("h4:h6").Select
Selection.Clear
ActiveSheet.Shapes("Frame1").Visible = False
End SubCould someone help me adding the additional code that would clear the Frame for old data.
(Extra question: If the Frame is cleared for old data, does that also clear the controlsource cells?)
-B
Last edited by a moderator:
