Create new macro

[fozo]

Hello everyone,

I am trying to attempt to get my first macro on excel.

Here is what it looks like. I have 3 column A-C.

On cell C1: I want to have the word "Hold", then highlight the cell with red color back ground. Then, it goes to column A and clear up the content on cell A1.

How can I write macro for it?

Second question: how do I use that macro to apply whichever cells below?

Hope I don't confuse you guys.

Thanks.

 

[jolivanes]

When you used the macro recorder to record the steps you described, what did it come up with?

 

[Iexel]

Hi jolivanes! Great quote by the way.

Well I am new here and I am looking for an answer to my thread but I think I can help you!!!

After doing your macro recorder, open VBA, and all the code is there. You then can pick up what do you want for another macro recorder and as well change what it is written.

 

[JLGWhiz]

Hi fozo, There is nothing magical about writing macros. It is simply using the VBA program language to identify workbook, worksheet and control objects and their properties and execute events in a logical order. Most simple macros can be written using the macro recorder. Just turn the recorder on, then proceed to do the steps manually that you want the macro to do, then turn the recorder off. Test the macro to see if you get the results you want. If not, then post the macro you recorded to a thread on this site, with an explanation of what you were trying to do, and somebody will likely assist you in getting the macro to work. Most recorded macros do not look like what you see from responders on this site. The recorded macros are much more wordy with a lot of select and scroll. That is because the recorder will record your every action, even the ones that are meaningless. After you learn something about macros, you will be able to record one and then clean it up so it does not look so bulky.