Forum Discussion

CLeslie79's avatar
CLeslie79
Copper Contributor
May 03, 2023
Solved

Copy form Cell(s) on Sheet A to Sheet B if Cell A changes, then clear cells on Sheet A

Ok, this may have been asked before but here is what I am working with. I am new to coding in Excel with MB and/or Macros so any assistance is appreciated. I have looked over some other code alrea...
  • ecovonrein's avatar
    May 05, 2023
    The easiest way by far to get into VBA for Excel is to "Record Macro". The relevant button is on the "Developer" ribbon, which is hidden by default. Add it to your ribbon via File/Options. Start recording and simply execute the actions you want performed. Stop recording and behold what macro the recorder has produced. Optimize manually after.

    Know also that ChatGBT is a confident coder in VBA.