Recent content by ganzzu

Hi Narayan, The above function works well and I will use it for the database. Thanks again!

Hi Narayan and thank you for the hint. I will use it when dealing with the database myself so that I won't change the Month name formula. But there are also other people who will keep using the other date format (mm.dd.yyyy) so it's easier to implement for them the next formula...

Hi, In a database I'm using, column A is the Date. Based on the value the cells from that column I built a formula so that I get the month name: =IF(AND(A3>=41275,A3<=41305),"January",IF(AND(A3>=41306,A3<=41333),"February" etc. The format of the cells in column A has to be changed and...

Hi, Thank you all for taking time from yourselves and trying to help. I tried Narayan's proposal and it worked ok. However, I solved the issue in a different (and easier from the code point of view) manner. I dropped the 2nd text data (he Suffix) from the displaying text string. I will only...

Hi, In a file I am working on I have to add 2 information (which is selected from 2 lists) to a given event name (1 text information before the event name and 1 text information after the event name) and display it in a cell. For example: Event name - Christmas 1st information - Schools...

Hi Narayan, I've been a little dumb. The code you gave me in 2nd post works fine and solves the issue, but instead of adding it below, I replaced 2nd line of my own code. I think it's obvious I'm a begginner at VBA and I'm sorry if a made you waste some more time on this and big thanks for...

Hi Narayan and thanks again for trying to help, Maybe the details a tried to give earlier were not so clear. I was saying that I tried to modify the code so that it displays the needed BOLD chars, but I either wrote something wrong (and the error was displayed) or it simply didn't display the...

Hi again, Tried various ways of making that text bold, but no results. Every time I try something, it keeps displaying only the value in 'e.Cells(xee, 3).Value' and it does not also add '[Sch]:' text. Any other ideas on how I can resolve this? Thanks!

Hi Narayan, Thanks for your response. I tried your formula but, for some reason, it does not entirely work. There may be some other dependencies in the code. I will check a bit more to see if I see something else there. Thanks again!

Hey, I have the following code: ElseIf UCase(e.Cells(xee, 5).Value) = "SCHOOLS" Then o.Cells((6 * (j - 1) + q), 6).Formula = "[Sch]: " & e.Cells(xee, 3).Value It does the following thing: when 'Schools' are selected from a drop-down list, '[Sch]:' text is displayed in the sheet that...

I managed to clean up and repair a bit the code, deleted unnecessary things and I customized 3 files for 3 different years (gave up trying to modify the code in order to keep same file for multiple years). Now I have to find a way to fulfil another requirement - If some events are copy/pasted...

Hi again, I cannot thank you enough if you can help even just for a bit. Regards

Hi, Yes, I saw that module 1 code but I thought there may be some small modifications to that code in order to fulfil the requirements for the next year(s). This has to be completed for next week. Regards

Hi, I have received this Excel calendar template file: http://db.tt/eUVa1G60 The requirement would be to modify it in order to add events in the database for at least year 2013 (but it would be perfect to be able to also add for 2014, 2015 and so on) and the calendar (the Overview and each...