Hi all - is there a formula / function / macro (although I don't have any experience in creating macros) that can be used to clear cells that require input?
e.g. refer to the sample attachment.
If I click on cell C11 in the "Input date" sheet, I'd like the values at cells B12:B17 (Job 1 tab), B12:B17 (Job 2 tab) and B12:B15 (Job 3 tab) to be cleared to blank. Is this possible?
There is no "single click" event for cell, but "double click"
Right click on tab name, view code, then paste below code into.
This code trigger "double click" event on cell C11:
PHP Code:Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address(0, 0) <> "C11" Then Exit Sub
Sheets("Job 1").Range("B12:B17").ClearContents
Sheets("Job 2").Range("B12:B17").ClearContents
Sheets("Job 3").Range("B12:B15").ClearContents
Cancel = True
End Sub
Quang PT
Is that not the Worksheet Selection Change Event handler?There is no "single click" event for cell, . . .
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
No, to avoid single click by change...Originally Posted by TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks