clear a dashed line

**Slashalot** · 09-13-2007, 08:47 AM

i am close to getting my code complete but have 2 bugs.

1: can the copied cell dashed lines be cleared after the paste in VBA?
2: how do i get the Sub to run when cell value changes? it runs fine if i "run" it inside the VB editor.

Please Login or Register  to view this content.

thanks

**mudraker** · 09-13-2007, 08:51 AM

Slashalot

Welcome to excelforum

Please read forum rules & wrap your VBA code

See links below for rules
A thread with the rules is also available at the top of each forum

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

**Slashalot** · 09-13-2007, 11:14 AM

hopefully some can help as i am way new to excel but here goes:

this is a dart throw recording sheet. i want to insert a row with the formulas when $E$5 becomes populated with a value. i almost have it complete with a VBA code but it won't activate when the cell ($E$5) changes, however it will work correctly if i populate the cell then "run" the code from the editor.

can someone help me?

when i get this problem fixed, i want to utilize an input box for A5, C5, E5 to get the dart throws. but 1 problem at a time.

**Leith Ross** · 09-13-2007, 12:51 PM

Hello Slashalot,

Your coding is sound. The problem lies in the Data Validation Drop Down. This doesn't trigger any events in VBA eventhough the worksheet has changed. You could use either a Forms Drop Down or a Control Toolbox ComboBox in place of the Data Validation Drop Down. This will require you to write a bit more coding for the control.

Sincerely,
Leith Ross

**Slashalot** · 09-13-2007, 01:00 PM

thankyou much Leith.

can i control what can be typed into an "input" box and use that for the trigger or does that also have the same problem?

hmmmm, i tried to force the trigger by removing the validation portion of cell E5 but still no joy.