hi friends,
if u check my file u can see some comments in calender sheet in january but i want to apply this for other months by repayment dates..
hi friends,
if u check my file u can see some comments in calender sheet in january but i want to apply this for other months by repayment dates..
Hi MUSTAFAINE,
welcome to the forum. Please try not to use chat room code, there may be users here who don't understand it.
As to your problem, copy the cell with the comment, then use Paste Special and tick Comments. To also apply the format, use Paste Special a second time and tick Format.
hth
sorry teylyn, i am droogie now.. my matter is some payments are monthly some one is quarterly so i must lookup the payment values in repayment sheet and add new comment the other month calender..
That would require VBA outside of my skill range. I just want to alert you to the fact that the comments will stay in the cells, even if you use the slider to select a different year. Again, it may be possible to use VBA to delete all existing comments and recalculate upon slider usage, but you'd have to find a VBA expert for that.
I'll move the thread to the Programming forum.
my skill range too teylyn dont worry :D
Mustafaine,
Let me first complement you on this sheet. I must say that it looks very nice. Well done. Two thumbs up.
Having that said I would like to address Teylyn as she is walking away from this as where I think so can be of help.
Your sheet has a CF on all the calander dates, using:
=NOT(ISNA(MATCH(C5,repayment,0)))
This is clever, but it does not take into account the running perod and the intervals.
Running period: Simply solved with
=IF(theyear<YEAR(B3),"Not Started",IF(theyear>YEAR(C3),"Ended",DATE(theyear,F$2,E3)))
Payments: Need to think about that one
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thanks rwgrietveld, i like your "not started,ended" function, why i cant think that
but i am still need vba codes for the other months, and i did the january`s comment please check my file again, when you click scroll comments will be deleted but if you click again will be add again..
I want to refresh this thread..
Mustifane,
Welcome to the Forum.
I'd like to draw your attention to the Forum Rules
I'll post the link, this time. Next time, please remember.8. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!
http://www.mrexcel.com/forum/showthread.php?t=437597
There is link to a good description of polite cross-posting in my signature.
Last edited by mikerickson; 12-25-2009 at 04:33 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
i`m sorry mikerickson i didnt read the rules i`ll check it..
i changed something in vba codes olease check new version, maybe you can give ideas for the editing this file
its ok. check it..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks