vba help please

[shyamvinjamuri]

Is there a way to run code when the value changes in a cell (eg. A25)?
A25 has the result from a drop down selection
I am using Excel 2007

Please help
Thanks

 

[hiker95]

shyamvinjamuri,

Yes, you can use the Worksheet_Change Event.

Can you explain in more details?

 

[pboltonchina]

Try this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$25" Then

'Put your code here
End If
End Sub

 

[shyamvinjamuri]

In sheet1 I have a dropdown for months (jan, Feb...etc).
cell A25 has the result from the dropdown selection.
Depending on the month selected, I copy data from that month into the sheet1 starting at cell A26

Thanks

 

[hiker95]

shyamvinjamuri,

Please attach screenshots of your workbook or a sample workbook that accurately portrays your current workbook on one sheet, and what it should look like 'After' on another sheet.

This makes it much easier to see exactly what you want to do, as well as shows us whether there is a consistent number of rows between tables and such.

Here are three possible ways to post small (copyable) screen shots directly in your post:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

or
RichardSchollar’s beta HTML Maker -...his signature block at the bottom of his post

or
Borders-Copy-Paste



If you are not able to give us screenshots:

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

You can upload your workbook to www.box.net and provide us with a link to your workbook.

 

[shyamvinjamuri]

pboltonchina

I tried, but it is not triggering my code when the dropdown selection is changed

 

[Ruddles]

Is there a way to run code when the value changes in a cell (eg. A25)?
A25 has the result from a drop down selection
I am using Excel 2007

Someone asked this question in the last couple of days. Have you done a search?

 

[pboltonchina]

The code should be put in the sheet you want it to work on.

 

[Ruddles]

Here: http://www.mrexcel.com/forum/showpost.php?p=2628354&postcount=12.

 

[shyamvinjamuri]

Perfect.
Thank you all
Thank you Ruddles. It worked for me.