Skip to main content

VBA excel automatic date when value add

 In Microsoft Excel, you can use Visual Basic for Applications (VBA) to automatically enter a date in a cell when a value is added. Here's an example of how you can do this: Press Alt + F11 to open the VBA editor. Right-click the sheet tab where you want to add the date, then select "View Code". In the code editor, paste the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("A1:A10")) Is Nothing Then Target.Offset(0, 1).Value = Date End If End Sub Close the code editor by clicking the "X" in the top-right corner. This code will automatically enter the current date in the cell next to the active cell whenever a value is added in the cells from A1 to A10. If you want to change the range of cells, you can modify the range in the line "If Not Intersect(Target, Range("A1:A10")) Is Nothing Then". Note: This code works in all recent versions of Micr...
Post a Comment

Windows shortcut keys

 Here are some common Windows shortcut keys:


Windows key + E: Open File Explorer

Windows key + R: Open the Run dialog box

Windows key + L: Lock your computer or switch accounts

Windows key + T: Cycle through apps on the taskbar

Windows key + D: Show the desktop

Windows key + P: Project to a different screen

Windows key + Tab: Open the Task View

Windows key + Ctrl + D: Create a new virtual desktop

Windows key + Ctrl + Right arrow: Switch to the next virtual desktop

Windows key + Ctrl + Left arrow: Switch to the previous virtual desktop

Windows key + Ctrl + F4: Close the current virtual desktop

Windows key + Alt + Tab: Switch between open apps

Windows key + Shift + S: Take a screenshot (Windows 10 only)

Ctrl + C: Copy

Ctrl + X: Cut

Ctrl + V: Paste

Ctrl + A: Select all

Ctrl + Z: Undo

Ctrl + Y: Redo

Ctrl + N: Open a new window or document

Ctrl + W: Close the current window or document

Alt + Tab: Switch between open windows or programs

Windows key + D: Show the desktop

Windows key + E: Open File Explorer

Windows key + L: Lock the computer

Windows key + R: Open the Run dialog box

Windows key + P: Project the screen to another display

Windows key + T: Cycle through the apps on the taskbar

Please note that these are some common shortcuts, but it could vary depending on the version of Windows and the application being used.

Comments

Post a Comment

Popular posts from this blog

What is Brand Marketing

Brand marketing is the process of building and maintaining a strong and recognizable brand. A brand is more than just a logo or a name, it is the perception that a customer has of a product or service. A strong brand can help to differentiate a company's offerings from its competitors and create a sense of trust and loyalty among customers. There are several key elements of brand marketing, including: Brand Identity: This includes the visual elements of the brand, such as the logo, color scheme, and typography, as well as the brand's name and tagline. Brand Strategy: This includes the overall positioning of the brand, the target audience, and the key messaging. Brand Communications: This includes the various tactics and channels used to communicate the brand, such as advertising, public relations, and social media. Brand Experience: This includes the overall customer experience, from the product or service itself to the customer service and support. Brand Management: This inclu...
Post a Comment
Read more

Snake game using Javascript

Here is an example of a basic snake game using JavaScript: // canvas setup var canvas = document.getElementById("snake-game"); var ctx = canvas.getContext("2d"); // game variables var snake = [{x: 150, y: 150}]; var direction = "right"; var foodX = Math.floor(Math.random() * canvas.width); var foodY = Math.floor(Math.random() * canvas.height); var score = 0; // game loop setInterval(function() {   // clear the canvas   ctx.clearRect(0, 0, canvas.width, canvas.height);   // draw food   ctx.fillStyle = "red";   ctx.fillRect(foodX, foodY, 10, 10);   // move snake   var head = {x: snake[0].x, y: snake[0].y};   if (direction === "right") {     head.x += 10;   } else if (direction === "left") {     head.x -= 10;   } else if (direction === "up") {     head.y -= 10;   } else if (direction === "down") {     head.y += 10;   }   snake.unshift(head);   // check for collision with food ...
Post a Comment
Read more