Hey all,
I have been trying to write some code that will use an event macro so as when I enter a value in "A:A" borders will appear in that row until a specified column.
Eg, enter value into A1 and borders appear in Row 1 until column 10.
I just can't seem to do it, any help would be great.
Last edited by JapanDave; 11-30-2011 at 10:30 AM.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
try sch code:
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Great. Why did I not think of the resize!!!
One last question, how would I go about having those borders disappear when the value is deleted?
have fun
Please Login or Register to view this content.
Thanks Tom!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks