ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Recording new Macro won't reset drop downs (https://www.excelbanter.com/excel-discussion-misc-queries/252348-recording-new-macro-wont-reset-drop-downs.html)

Project Pooped!

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

Per Jessen

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



Project Pooped!

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


.


Per Jessen

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