View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maria[_6_] Maria[_6_] is offline
external usenet poster
 
Posts: 10
Default Selection change: How to run a Macro

Hello:
I would appreciate help with the following:

Cell A1 has a dropdown list (Data, Validation feature) which allows user to
select from one of three choice.

Based on the value in cell A1, cells B1, B2, B3 have different values. I
have written a macro to enter those specific values in cells B1:B3 based on
the value in cell A1.

What kind of code do I need in the SelectionChange to be able to populate
B1:B3 with the correct values based on user selection in cell A1

TIA


--
Maria