Where do I paste in VBA?

[lukerees83]

I have never used VBA in my life before, and someone has given me a solution to one of my problems in the form of VBA code:

With Range("A1")
.Value = Replace(.Value, "+", ":")
End With


How do I apply this, is there a box to simply paste VBA into?

(Excel 2011 Mac)

 

[sahild05]

-hit alt+f11
-when vba window shows up, in the insert menu, select module
-name the sub (type in "sub rep_plus_sign" on the first line of the module)
-hit enter (end sub statement should be created automatically)
-between the two statements, paste your code
-running - hit alt+f8, select your macro, and run

 

[JamesW]

Hi,

Press Alt + F11 to open the VB screen. You should see the code window in the middle (where you write/paste code) and the project explorer on the left (this is where you can change which sheet/module you are working on).

I suggest looking here: http://www.vbtutor.net/VBA/vba_chp1.htm

P.S. That code can be done by selecting cell A1 and pressing CTRL + H.