var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: run macro upon selection
this is a start.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then <---i need this to be a range a1:g10
MsgBox "Cell " & Target.Address & " has changed."
i have a range of cells
if any cell within this range is selected i would like for a macro to be run automatically. i gto this part torun with this code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column >= 3 And Target.Column <= 25 And (Target.Row >= 2 And Target.Row <= 19) Then
instead of the message box i need it to do the next step.
when cell is selected a box would come up with options of selecting 1-6.
value of selected cell would copy to cell assign to option.