VALIDATION IN MACRO
I want a Macro to refer to the validation Cell (which has list of States)
enabling user to select the state. The Macro should direct the user to the cell, choose and continue the processing. Based on the selection, a series of macros will work applicable for the state. |
VALIDATION IN MACRO
Not sure I fully understand, but take a look at Data Validation, referring
to your list as valid values. The user can then select from a drop down of valid values. No need for any code. -- Regards, Nigel "Ananth" wrote in message ... I want a Macro to refer to the validation Cell (which has list of States) enabling user to select the state. The Macro should direct the user to the cell, choose and continue the processing. Based on the selection, a series of macros will work applicable for the state. |
All times are GMT +1. The time now is 05:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com