Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-21-2020, 01:34 PM
vastolorde vastolorde is offline Way to autoshift cells down Windows 10 Way to autoshift cells down Office 2019
Novice
Way to autoshift cells down
 
Join Date: Jan 2020
Posts: 1
vastolorde is on a distinguished road
Default Way to autoshift cells down


I am building a sheet in which I would like to input a value under the verify value space, green cell, and then when i hit enter the value i entered to shift down. Ultimately the values i enter will verify with values under values 2 cell, red cell, but I am already aware of how to do this. Thanks in advance!
Attached Images
File Type: png Capture.PNG (4.6 KB, 13 views)
Reply With Quote
  #2  
Old 01-21-2020, 02:17 PM
Logit Logit is offline Way to autoshift cells down Windows 10 Way to autoshift cells down Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Here is one method :

Paste in the Sheet Level Module :

Code:
Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Range("G2").Value <> "" Then
        Range("G2").Insert Shift:=xlDown
    End If
End Sub
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Way to autoshift cells down Converting table to text (and back) with carriage returns in cells, split and merged cells ndajko Word 5 11-04-2019 07:53 AM
Borders on merged cells also appearing on unwanted adjacent cells MrsC Word Tables 2 08-19-2019 09:14 AM
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
Way to autoshift cells down Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft