Search results for query: *

The clue was in the fact that the variable only has life whilst the procedure is running. Previously, the code to build the report was resdient in the worksheet that the "update Stats" button lives in. Of course, as soon as you click that button, you invoke the User Form, so, by moving the...

Thanks Skip. Fixed it. Regards.

Hello Skip, This is a further development of the training course tracking spreadsheet that you have given me some guidance for already. Basically, I am building a spreadsheet to be used as a tool in tracking training and development activities undertaken within a specific department. As part...

Thanks once again Skip. Guess this code goes into my Worksheet code? Because I'm trying to get the date value into the 'Lrd' variable, do I need the YourRangeObject? Best regards, Ian.

Something that I am currently working on requires a date to be input. Ideally, I will then be using this date as a variable, for use in some other VBA macros. Having read many, many online tips (and after consulting my Excel VBA for Dummies), I have managed to get a calendar working. I have...

Doh!!

Hi and thanks for the replies, Skip, adding the row number to the Debug Print highlighted a problem - it was starting at about 200. In turn this prompted me to look more closely at the "Providers Mapping" sheet (which had been provided to me by someone esle). Becuase, I have had a bit of...

I wonder if someone can help me with this. Currently, I am trying to build a spreadsheet that tracks training courses taken. Part of this will be a 'stats' page, which the user and their manager can use to discuss progress against individual plans. I need the facility to enter a 'last...

Thanks for that Skip. Just out of curiosity, how does the COUNTIF do the compare to establish if the date is more that 30 days old? The only way that I could think of doing it was to compare to today's date - and that's the part I didn't seem to be able to do with COUNTIFs. Thanks again, Ian.

Thanks Skip - worked like a charm. Greatly appreciate your help. Cheers, Ian.

OK, Gave that a try. Indeed, they did convert to numbers, so are real dates. Very confused now!!!

Thanks - think my reply must have crossed with your - I'll give that a try. Cheers.

OK, so maybe the question is: why would it return text from cells that are formatted as dates?

Yes - that was my first thought. Tried to do it with COUNTIFs, but couldn't seem to get that to work. Also wanted to assign the update action to a button - so VBA seemed like the way to go. As I say, I'm quite new to this, so I'll be grateful for any guidance. Cheers.

Hi there, OK, I'm a bit new to VBA - and new to this forum - so please be gentle!!! Currently, I am building an Excel spreadsheet to manage training records. At the moment, I am trying to put together a routine, which interrogates a list of 'Date of completion' dates (relating to the dates...