tom_blamire
Board Regular
- Joined
- Dec 13, 2012
- Messages
- 99
hi all,
I am having a major problem where I have come to a halt on finding a solution. This is my problem:
I have a worksheet where there is a drop down (cell c18:g18 - this is a merged cell), if "Cloud" is selected then I need excel to make it run a certain macro whereby the range in c21:c37 become a data validation list from the information stored in range in T1:T6.
Now, if "Cloud" isn't selected and another choice is made, I need the range in C21:c37 to become a free text field.
Is this possible?
Kind regards in advance
Tom
I am having a major problem where I have come to a halt on finding a solution. This is my problem:
I have a worksheet where there is a drop down (cell c18:g18 - this is a merged cell), if "Cloud" is selected then I need excel to make it run a certain macro whereby the range in c21:c37 become a data validation list from the information stored in range in T1:T6.
Now, if "Cloud" isn't selected and another choice is made, I need the range in C21:c37 to become a free text field.
Is this possible?
Kind regards in advance
Tom