![]() |
Recording new Macro won't reset drop downs
The title pretty much says it all. I am creating a "Clear Sheet" macro.
When recording the macro I am clearing all data from necessary fields. However, I have a drop down with 5 account code numbers and one blank spot. When I am recording the macro I reset manually the drop down arrow to the blank choice. When I complete recording and run the "Clear Sheet" macro it clears everything out fine, but does not change the drop down to the blank spot. Can anyone tell me what I am doing wrong, or perhaps a better way of getting around this problem. Thanks in Advance |
Recording new Macro won't reset drop downs
Hi
Change A1 to the address of your drop down cell. Range("A1") = "" Regards, Per "Project Pooped!" skrev i meddelelsen ... The title pretty much says it all. I am creating a "Clear Sheet" macro. When recording the macro I am clearing all data from necessary fields. However, I have a drop down with 5 account code numbers and one blank spot. When I am recording the macro I reset manually the drop down arrow to the blank choice. When I complete recording and run the "Clear Sheet" macro it clears everything out fine, but does not change the drop down to the blank spot. Can anyone tell me what I am doing wrong, or perhaps a better way of getting around this problem. Thanks in Advance |
Recording new Macro won't reset drop downs
I'm not sure, but I think I am beginning to grasp. A1 in this case is blank,
correct? "Per Jessen" wrote: Hi Change A1 to the address of your drop down cell. Range("A1") = "" Regards, Per "Project Pooped!" skrev i meddelelsen ... The title pretty much says it all. I am creating a "Clear Sheet" macro. When recording the macro I am clearing all data from necessary fields. However, I have a drop down with 5 account code numbers and one blank spot. When I am recording the macro I reset manually the drop down arrow to the blank choice. When I complete recording and run the "Clear Sheet" macro it clears everything out fine, but does not change the drop down to the blank spot. Can anyone tell me what I am doing wrong, or perhaps a better way of getting around this problem. Thanks in Advance . |
Recording new Macro won't reset drop downs
Yes, A1 will be blank (none of the values in the validation list are
selected) "Project Pooped!" skrev i meddelelsen ... I'm not sure, but I think I am beginning to grasp. A1 in this case is blank, correct? "Per Jessen" wrote: Hi Change A1 to the address of your drop down cell. Range("A1") = "" Regards, Per "Project Pooped!" skrev i meddelelsen ... The title pretty much says it all. I am creating a "Clear Sheet" macro. When recording the macro I am clearing all data from necessary fields. However, I have a drop down with 5 account code numbers and one blank spot. When I am recording the macro I reset manually the drop down arrow to the blank choice. When I complete recording and run the "Clear Sheet" macro it clears everything out fine, but does not change the drop down to the blank spot. Can anyone tell me what I am doing wrong, or perhaps a better way of getting around this problem. Thanks in Advance . |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com