VBA Automatically move cells after data from a drop down list is entered or changed

**Crawfy** · 12-28-2020, 05:17 AM

I have tried the below code on a sheet in an attempt to move to a different cell/column after entering data/changing data in a particular range of cells by using their dropdown list (via data validation).
The range the drop-down lists are in is a named range DataFacilityInput. These are cells in a column of a table.
After any of these are entered for the first time, or changed in the future, I want excel to automatically jump 5 cells to the right into the respective cell of another row I need to update data in.

I can get this code to work only once for any of the DataFacilityInput cells, only if the row is newly added to the table, but then it will not work for any of the preexisting data.

I am trying to get this to work for two columns. DataFacilityInput & DataInitiatedBy

Any suggestions you may have will help. Thx

Please Login or Register  to view this content.

**BadlySpelledBuoy** · 12-28-2020, 06:05 AM

I've just mocked up a workbook to do what I think you're trying here, using your code as above, and all works fine for me.

Perhaps there's an issue with your workbook that is preventing it. Could you attach a desensitized version of it so we can investigate?

BSB

**Crawfy** · 12-28-2020, 04:44 PM

Thank you. Attached file without changes.
I tried your file which obviously worked. I then copied it into my workbook where it continued to work properly. However, after copying the vba code from your sheet to my sheet, my sheet does not work. Not sure what is going on but I'll take a closer look at the coding etc on my sheet.

Just looked at the Name Manager and discovered my range is not updating when rows are added to the table. Any idea how to ensure all added rows or filtering of the table is reflected dynamically in the named range?

**BadlySpelledBuoy** · 12-28-2020, 05:03 PM

The two named ranges called upon by your change event do not cover the whole height of the table. One covers only rows 18:24 and the other 15:24.

If you change cells within those ranges all works as planned, but outside of that then nothing happens because the range is outside of where the INTERSECT in the macro is looking.

I've resized them in the attached and all appears to be working.

BSB

**Crawfy** · 12-29-2020, 01:04 AM

Thank you for all your help.

VBA Automatically move cells after data from a drop down list is entered or changed

LinkBack

Thread Tools

Rate This Thread

Display

VBA Automatically move cells after data from a drop down list is entered or changed

Re: VBA Automatically move cells after data from a drop down list is entered or changed

Re: VBA Automatically move cells after data from a drop down list is entered or changed

Re: VBA Automatically move cells after data from a drop down list is entered or changed

Re: VBA Automatically move cells after data from a drop down list is entered or changed

Thread Information

Users Browsing this Thread

Similar Threads

Automatically Sorting a List by Name as New Data is Entered

Data validation: Drop down list changed source by itself

[SOLVED] Move cursor to the right automatically after data is entered/selected from the drop downs

[SOLVED] Execute data label coloring code when drop down list changed

[SOLVED] Lock specific cells once a value is entered with a drop down list

[SOLVED] Excel 2007: modified drop down list, can entries already entered be updated automatically?

[SOLVED] Can cells have the bkground color changed upon selection of an item from a drop-down list?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions