Rookie needs help - upon dropdown selection

D

drizzamed

New Member
Joined
Sep 13, 2013
Messages
6
In cell J5 I have a drop down to select Yes or No. What I would like to happen is if Yes is selected, A5 through G5 is cleared and the drop down is reset to a blank and ready for Yes or No to be chosen when the cells are filled out again. Each row is formatted the same all the way to row 49 and column J will always be a Yes or No dropdown.

Help!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
If it helps or makes it easier, I can make the cells fill a certain color when Yes is selected. Maybe we can then clear the cells that contain that fill color? Then somehow change the dropdown to none selected?
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
VBA Code help for hiding rows and column based on dropdown selections
Replies
2
Views
274
suzette0735
S
C
  • Question
How to Clear a Drop-Down selection whit a button
Replies
3
Views
629
Joe4
Joe4
T
  • Solved
Hiding A row based on second work sheet based on Yes / No dropdown on first work sheet help....
Replies
5
Views
378
James006
James006
O
  • Question
VBA - Archive sheet help
Replies
2
Views
237
Omi2804
O
C
  • Question
Reset user form combo box to top record
Replies
5
Views
420
James006
James006

Forum statistics

Threads
1,206,754
Messages
6,074,752
Members
446,083
Latest member
kfunt

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top