1. B

    how to get Date Picker in userform

    Can somebody tell me how to get the calender control in the UserForm? I don't find it in my additional tools
  2. D

    Extract specific numbers from a text string, and extract range

    Hello, this is a bit of an odd query, I am trying to convert a student timetable into an excel spreadsheet (then create a calendar with it), but the data I have been given is in an awkward format. It would be easier to give an example: I recieve a cell containing a list of weeks a certain class...
  3. K

    Date/Calender formula

    Hi, I am trying to make a formula that take a certain period of time (M-1, M0, M1, M2, M3 and M4) So the previous month and 5 month ahead. I made a similar code for the past 6 month...
  4. S

    Producting calender from list or vice versa

    Morning all, new user here :) A team utilises a spreadsheet laid out in a calender format similar to the following <tbody> Customer 22/2 23/2 24/2 25/2 26/2 27/2 28/2 1/3 ... A Job 1 Job 2 B Job1 & 2 Job 4 ... </tbody> But my job would be 1000x easier for all...
  5. N

    [Excel 2010] Formatting calender depending on list of dates

    <tbody> dates M T W T F S S 01/27/2017 16 17 18 19 20 21 22 01/28/2017 23 24 25 26 27 28 29 01/29/2017 30 31 1 2 3 4 5 02/02/2017 6 7 8 9 10 11 12 </tbody> Hey! All I want to do is to highlight every day in the primitive calendar on the right that is stored on the left in the...
  6. T

    Calender project

    Hi guys, I've recently started working offshore and to kill some of the time I have I thought I'd try and create a comprehensive calender that tracks the following. vessel worked on sector worked in eg UK, US, Asia days worked I'd like to have a calendar that is perhaps linked to a...
  7. ReLISTO

    Prorate Rent

    Hello. Help needed... I am trying to create a formula to determine the amount of rent due for not only the start of the lease but for the full term of the lease itself.. For the following problems I would like to have a formula that could be utilized over and over again. Lease Starts On...
  8. M

    VBA Code that Sums on a Loop Based on Criteria and Linked to Calender

    Hi guys, What I'm trying to do is too complex for a regular Excel formula, so I need a VBA. Unfortunately, I know very little about VBA, so I'm really counting on this forum. I think this might be a challenging VBA, but hopefully fun too! As it is now, column CH has a formula that takes the...
  9. B

    I would like to create a visual calender that you can click to acess certain data. ??

    Excel 10 Noobie lvl at the moment Hey. I am creating a spreadsheet that employees will enter data in everyday. I need to know what is the best way to insert an interactive calender that when you click on a certain date you will be directed to the coresponding data worksheets for that day. Any...
  10. A

    User form and date

    Hi, How can i enable my user to go into user form and choose a specific day from a calender ? i allready have the user form i just cant find the calender in order to deploy it in the from. Thanks, Aviad
  11. F

    Calendar which auto populates

    Dear Community, Been using your forum for a long time and decided to make my own account today to post my first question, to which I did not find an answer which worked for me so far... So here my problem: I have a list of items which all mature on different dates and all have a certain money...
  12. G

    Calender control 12 size changes

    Hi I was wondering if anyone could help me a problem, I have created an Expenditure sheet showing my monthly bills. I have placed a calender Object on the sheet. I have reduced it to a certain size so it fits in a certain position, and in design mode it fits but when I come out of design...
  13. B

    Highlight current date cell

    Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am working on a calendar where I need the current day to be highlighted. I know how to do it with conditional formatting but I would like to use VB for it. I have come up with the following code but...

Some videos you may like

This Week's Hot Topics