I AM A BEGINNER,
Can someone see why this programing does not work? I would like to have it fill in several cells with different contact information when i select a name...(email, office phone, cell number...).
Right now i get a Run-time error "Method 'Value' of object 'Range' failed.
If someone could take a look at this i would really appreciate it.
Please Login or Register to view this content.
Last edited by GarryR; 04-04-2012 at 11:28 AM.
Maybe There is better way all togheter to do this???
Hi GarryR
Welcome to the Forum!
Remove the code from the ThisWorkBook Module and place this code in Sheet1 ModulePlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
WOW!! thanks it works!
And if i want to apply this same kind of programming to cell (J4) is it just a matter of copying the same thing and changinf the cell refereences after the end sub?
Hi GarryR
Since you have the lists and Named Ranges created, this is how I'd suggest you approach itPlease Login or Register to view this content.
That last code dosent seem to do anything...
Hi GarryR
Sorry about that, Events were getting turned off but not back on...try thisPlease Login or Register to view this content.
Amazing John.
Works like a charm!
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks