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.
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.
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?
Sincerely,
Jeff
Maybe it's a enablevents issue
Try
VBA NoobPlease Login or Register to view this content.
Last edited by VBA Noob; 10-19-2007 at 12:04 PM.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
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
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
This should turn events back on and event macro should work againPlease Login or Register to view this content.
VBA Noob
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks