I want to clear a cell when changing value from a drop-down list in another cell.
Se attached example.
Whenever I change player name in cell E8 (from whatever name to any other name) I want to clear the editable cell F8.
Is this possible without VBA?
If not, I also humbly appreciate suggestions on the code.
thanks!ClearCell.xlsx
No, not possible without VBA. I'm moving this to the VBA section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ok thanks.
Anyone who knows the proper VBA code for the task?
All help appreciated
Try this !
According to your attachment a worksheet event VBA procedure to paste only to Blad1 worksheet module :
PHP Code:Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$8" Then
Application.EnableEvents = False
Target(1, 2).ClearContents
Application.EnableEvents = True
End If
End Sub
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
Works perfect, thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks