Search results

And thats by no means just a start, that would have taken me weeks. I am currently looking at the code to understand (as best I can) what its doing. Thank you very much for your assistance. Are you still willing to assist? Regards, Matt

I intended for the user to type in the answer, however the way inwhich the answer is to be entered will be as explicit as possible as I understand the issues with users typing in answers. Giving prompts and methods for entering the answers which I would like to include:- 01 - Artist 02 - Title...

I would like to create a game that plays up to ten seconds of music. At any stage the user can pause the music to answer the questions if they are succesful the score will appear if they are not they can restart the music and continue. Depending on how long it takes them to answer depends on...

Thank You Holger The more I review this the more I think that it is going to have to be a pivot table. I haven't created a pivot table yet so the next few weeks look interesting. Matt

Brilliant! Thanks very much, Its one of those add-ins that you miss when you don't have it. Thank you Matt

In a typical schedule (as attached) with information completed against a row and a column. Say that this schedule was completed by five different companies (currently only one can be shown in this method) Is there a way of creating a cubed schedule that theoretically each one of the schedules...

My PC recently crashed and I believe that I lost an Add-in named TM? I also lost the ASAP Utilities that Shades kindly refered me too but I have managed to find and load this back on. I do as mentioned before remember a TM next to the ASAP but cannot remember what it was for or where I got it...

Just for the hard of thinking like me is the A2 reference in: =Sum(First:Last!A2) The cell reference that is taken from all the worksheets between First & Last. In easy speak does it add all the results in range A2 from these worksheets. Regards, Matt

Brilliant, Thanks I can now see what the code sees when things are going RIGHT! Regards, Matt

Further on from my previous thread regarding Hyperlinks. I have changed a few things where one minute it appeared to work but now it has failed. When it shows an error and the Debug option is accepted in immediately takes you to the code with the problem (in yellow). This of course is a very...

Thank you Holger. Matt

Fully understand Holger please find attached file. All the worksheets are hidden as required leaving the index page. I tried to rename the "A1" ref but I still get the runtime error. Look forward to finding out where the problem(s) are. Thanks, Matt Please note that I have had to...

It didn't let me upload the file, so I will have a go again. Matt

Sorry Holger I didn't explain what I was after very clearly. The result I am looking for is that the text in each cell is centered around the "-". I have attached a file that I hope explains better than words. I would like the contents of the cell to align after the cell is changed...

HAHoBe Can you help please, I am getting a runtime error 9 on this line of code. I am unsure what this line of code does so I am unable to work out where it isn't working. Is it looking for the name of the worksheet that is to the left of the "!" in the hyperlink? I have placed a "!" as the...

Thank You HaHoBe Just what I was after, I will have a look through the code to see what has been written and how it works. Thanks, Matt

I have a number of cells that contains various lengths of text either side of a - within that cell. What I would like to happen Can I set the centre text justification so that the "-" is treated as the centre of each cell i.e So that this gegew - uudh ee-h dgdvgfdgg-d gsv-bgvdvcvdcdgsvcg...

Thank you Shades Look forward to hearing from you. Matt

I have a workbook that contains a worksheet (Index Page) with 53 hyperlinks to the related 53 worksheets that are hidden. What I would like to do 01 - Maintain the 53 worksheets as hidden unless the relevant hyperlink is clicked. Showing the page requested by clicking the hyperlink. 02 - Once...

Thank you Regards, Matt