Filling in text to the left and right of a cell

Hiya

Ok so im a noob when it coes to programming in excel, ive done vb.net stuff in the past, but im kind of stuck here!

Ive got 6 boxes, and im trying to make it so when a user enters info into a box the box to the left and box to the right get filled in with the text "unavailable"

I can get it to work one way or the other but not both! Excel just crashes!!

Here is the code im using:

Please Login or Register  to view this content.

Is there a better way to do this?

Any help would be great!

Thanks

Bob

Hello Bob,

Excel crashes due to an event cascade failure. You are using the Worksheet_Change event to capture when a cell is changed. When you change a cell in the event, the event calls it self again, and round round we go until there is no stack space left.

Fortunately, you can stop the madness. "Application.EnableEvents" controls the triggering of Excel's events. Always disable the events before you change a cell in the Worksheet_Change event, and re-enable the events before exiting the Sub.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hiya

Thanks for the replyies!!

Ive got it working perfectly now!

Just a note to the first post, the reason i can use formula is that i want people to type in the boxes, so a forumula would be deleted.

But the second alteration to my code is just the job!

Many many thanks

Bob