Macro to select something from the drop down list

[crack100]

Hi,


I have a workbook which has two dropdown lists consisting of dates . I want to write a macro which would automatically selects the 3rd/4th item in the second drop down list whenever the source data gets changed for the drop down list.

 

[Hui]

Crack100


Can you post a sample file for us to review?

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[crack100]

Hi Excel Ninja,


Please find my file . Refer link : https://hotfile.com/dl/195276015/4f0fb0a/Test1.xlsm.html


Dates are given in the tab "Date Source". The source for the drop down list is dynamic name range "Date". Now the date in the "Date Source" tab would change. So I want whenever the user updates the dates in the "Date Source" tab user clicks on one botton which would basically trigger a macro to automatically select a default value in the drop down list so that the table on the tab "DV" does not give #N/A.

 

[kaushik03]

Hi crack100,


Your problem is not clear to me.


Could you please answer my below questions?


1)According to your post, user has the provision to update dates in "Date Source" tab. Could you please tell us which cloumn (of "Date Source" tab) user could do so?


2)You want the drop down cell (H6, H7)to reset back to a 'DEFAULT VALUE' whenever user updates date in "Date Source" tab so that 'the table on the tab "DV" does not give #N/A'. My questions here are:


i) Which cells you are refering when you are expecting the #N/A' error?


In DV tab I could see formulae (linked cells) only in Col M , N and O. I could not see any of of these cells linked to any date value in "Date Source" tab. So I do not understand how could you expect #N/A' error while drop down value remain the same / dates get updated. I am sure I am missing something here. Please explain.


ii) What default value you want to set as for the drop down cells?


Looking forward to your responses.


Regards,

Kaushik