LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MP MP is offline
external usenet poster
 
Posts: 39
Default Clearing cells when selecting from a drop down list

I have cells on the worksheet that when you select an option from a drop down
list you type in a response. I need to clear these cells as a different
option is selected from the drop down list
i.e A1 - drop down list with options
A2 - cell will change with a a question depending upon what was selected
from A1
A3 - has response typed in i.e like the number 4 - this is what I need to
clear when someone goes back to A1 and selects something different

Thanks in advance
MP
 
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
Jump to next cell after selecting from drop down list Sandie Excel Worksheet Functions 8 November 16th 06 04:06 PM
Drop Down List choice selecting another drop down list CVD0722 Excel Worksheet Functions 3 October 31st 06 01:02 PM
clearing blanks in drop-down list Richard Walker Excel Discussion (Misc queries) 1 May 22nd 06 11:56 PM
Clearing the Values in a Drop - Down List Sagu Excel Discussion (Misc queries) 4 March 31st 06 03:32 AM
Selecting a line from a drop-down list Jonibenj Excel Discussion (Misc queries) 4 December 11th 05 05:46 PM


All times are GMT +1. The time now is 10:47 AM.

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"