Macro to utilize drop-down

[dshafique]

Hi everyone, I have a macro which edits and populates a template (which has other macros in it) and I need to populate a drop-down value for the month. The value is a numerical value of the current month, so I entered a code which would go to the cell "A15" and populate with the numerical value of the current month (10).

However, after populating it, the form doesn't work. Is there a macro which can select the drop-down and use the values in there as opposed to hard coding that cell?

Thanks : )

 

[Peter_SSs]

There should be no difference populating the cell directly via the code or via the drop-down. A possible cause of the problem could be that the code is entering the text "10" whereas the drop-down has a numeric 10, or vice-versa. Could that be the problem?

 

[dshafique]

There should be no difference populating the cell directly via the code or via the drop-down. A possible cause of the problem could be that the code is entering the text "10" whereas the drop-down has a numeric 10, or vice-versa. Could that be the problem?

Thanks for that. you are right. The number value i entered was a date format, so "10" was actually 44096 due to the date format.

With Range("C4")
.NumberFormat = "@"
.Value = Format(DateAdd("m", -1, Date), "m")
.NumberFormat = "General"
End With

this is what helped me. Thanks

 

[Peter_SSs]

You're welcome. Glad it helped.