Event Macro - Clear a group of cells

[jacobfromso]

Hello,
I would like to clear the contents of a group of cells base on the value of a single cell.
I have:
It loops until I hit ESC
Can someone please help me refine my code?

Please Login or Register  to view this content.

[boylejob]

jacobfromso,

I set up a worksheet on my end based on the information you provided in your post. I put QRC in D11 and data in H11, I11, D12, E12, H12, and I12. The minute I entered a value anywhere on the sheet it cleared the cells it was suppose to and stopped. Basically, your code worked fine on my end.

Is it possible for you to post your workbook so we can see if there is something else that is affecting thing on your end?

[VBA Noob]

Maybe it's a enablevents issue

Try

Please Login or Register  to view this content.

VBA Noob

[jacobfromso]

VBA Noob
That might have worked could you take a look at the attached and help me out?
Since I'm new at this I've done what I could but I could use some expert help here I think I'm getting over my head.

Thank you

[VBA Noob]

Try removing the merge cells and use format > cells > alignment > centre across selection.

Also move the non event macros to normal modules.

then in a normal module enter this and run

Please Login or Register  to view this content.

This should turn events back on and event macro should work again

VBA Noob

[jacobfromso]

I appreciate you looking at my worksheet but I have very little idea of what you are referring to.
What are “normal modules”?
What are modules for?
What will “format>cells>alignment>center across selection do?
What do you mean by “event macro”?

Sorry for all the questions
However after seeing what I can do with excel the more I want to do.
Thank again

[VBA Noob]

See link re modules.

Normal module is known on here as regular module

http://www.contextures.com/xlvba01.html

See links re event macro's
http://www.cpearson.com/excel/Events.aspx

http://www.mvps.org/dmcritchie/excel/event.htm

Instead of merging cells H12 and I12 it will make them look merge by center across selection. Sometimes you will have problems with code if cells are merged

HTH

VBA Noob