Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro
Hi,
Please help me do the following: I created a drop-down box to display data from cell A20-A25, and I want a macro (Called ClearData) that will reset that drop-down box to cell A20 when the macro is ran. Is this possible, thx, -- danny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro
Sub Reset()
Range("C5").Value = Range("A20").value End Sub -- __________________________________ HTH Bob "danny" wrote in message ... Hi, Please help me do the following: I created a drop-down box to display data from cell A20-A25, and I want a macro (Called ClearData) that will reset that drop-down box to cell A20 when the macro is ran. Is this possible, thx, -- danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |