Hi,
I recorded a macro and assigned it to a combo box (Active X control) which worked perfectly fine, however since adding another combo box which has a seperate macro assigned to it the 1st combo box macro has stopped working.
Half way through running the 1st macro it jumps to the second macro, if I could stop it doing this everything would be fine!
i assume the reason it jumps is because i am pasting data into the cells that combo box 2 is referencing. (it jumps on the line highlighted in bold
ets("HouselistWrking").Select
ActiveSheet.ShowAllData
Columns("DG:DG").Select
ActiveSheet.Range("$A$1:$DG$11802").AutoFilter Field:=110, Criteria1:="1"
Selection.Copy
Sheets("lookup").Select
Range("D1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Front").Select
Range("A2").Select
Hope you can help
Thanks,
Dan
I recorded a macro and assigned it to a combo box (Active X control) which worked perfectly fine, however since adding another combo box which has a seperate macro assigned to it the 1st combo box macro has stopped working.
Half way through running the 1st macro it jumps to the second macro, if I could stop it doing this everything would be fine!
i assume the reason it jumps is because i am pasting data into the cells that combo box 2 is referencing. (it jumps on the line highlighted in bold
ets("HouselistWrking").Select
ActiveSheet.ShowAllData
Columns("DG:DG").Select
ActiveSheet.Range("$A$1:$DG$11802").AutoFilter Field:=110, Criteria1:="1"
Selection.Copy
Sheets("lookup").Select
Range("D1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Front").Select
Range("A2").Select
Hope you can help
Thanks,
Dan