Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Fill cells automatically when cleared

Hello all,

Is there any way cells get automatically populated with certain value when cleared or made empty?

Example,

Value to put on empty cells: 1234

A1 = 11
A2 = empty
A3 = 22

If the automated fill works the cells should have:

A1 = 11
A2 = 1234
A3 = 22

If I empty A1 then 1234 should be put automatically in it.
If I fill A2 with 33 then A2 should contain 33 until I clear it, then it should have 1234 again.

Appreciate any help on this question.

Ronald.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Fill cells automatically when cleared

Hi,

Am Wed, 8 Mar 2017 04:26:04 -0800 (PST) schrieb R0nald:

Value to put on empty cells: 1234

A1 = 11
A2 = empty
A3 = 22

If the automated fill works the cells should have:

A1 = 11
A2 = 1234
A3 = 22


try:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub

If Len(Target) = 0 Then Target = 1234
End Sub


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Fill cells automatically when cleared

Thanks Claus!
Despite of all it doesn't do anything :-(

What I did: Just copy paste it on a new module I've created on a new workbook.....

Do I miss something or did you assume I handle it differently?

Best regards.

Ronald.
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Fill cells automatically when cleared

Hi,

Am Wed, 8 Mar 2017 07:33:53 -0800 (PST) schrieb R0nald:

Despite of all it doesn't do anything :-(

What I did: Just copy paste it on a new module I've created on a new workbook.....

Do I miss something or did you assume I handle it differently?


this is a worksheet event macro. Right click on the sheet tab of the
expected sheet = Show Code and paste the code into the code window.


Regards
Claus B.
--
Windows10
Office 2016
  #5   Report Post  
Banned
 
Posts: 1
Default

Tại sao nên in quảng cáo tại công ty in ấn Kim Minh Th*nh

+ Bạt in hiflex được lấy từ đầu nguồn, đảm bảo giá nguyên v*t liệu in ấn tốt nhất

+ Hệ thống máy in hiflex mực dầu, máy in khổ lớn trực tiếp thực hiện in, khổ in chiều rộng l* 3.2m, chiều d*i in ấn không hạn chế, in mọi k*ch thước phông nền như bạn mong muốn

+ Quy trình l*m việc chuyên nghiệp, rút ngắn nhiều công đoạn rườm r*, mang đến cho quý khách những điều kiện tốt nhất.

+ T*p thể thiết kế thiết kế v* in ấn gi*u kinh nghiệm.
Nguồn : in băng rôn


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Fill cells automatically when cleared

Thanks Claus.
All well now.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to automatically fill cells C Excel Programming 4 July 16th 09 04:35 PM
Undo Menu is Automatically Cleared jtarbell Excel Discussion (Misc queries) 1 November 15th 06 11:42 PM
Help using the 'If' function to automatically fill in other cells Bugaglugs Excel Worksheet Functions 3 August 21st 05 11:23 PM
automatically fill in a range of cells Maarten Excel Discussion (Misc queries) 1 April 29th 05 11:14 AM
need to fill cells automatically Feltond Excel Worksheet Functions 2 February 18th 05 11:56 PM


All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"