Recent content by advox1

Thanks Will try them and let you know the outcome. Jo

Hi Tony, Yes the only value which is being entered into the cell is the ":". Chance1234, I put a break in and the variables did hold. Any suggestions? Jo

Hi .value does not work sorry Tony, You are correct in that the listboxes are starthrs startmins endhrs and endmins. They are not multiselect. The values of these listboxes are defined from a rowsorce on the spreadsheet. As the name state the first list box starthrs goes from 07 - 22 for...

Hi I have a userform which once completed transfers the info into the next empty row of a worksheet. Problem is that four of the seleciotns are listboxes and for whatever reason the info selected by the user in the listbox will not transfer. The code I am using is as follows 'find next...

Hi I have a button which when clicked needs to open a folder to show the workbooks contained in that folder. The folder has a variable, so the folder path will look somehting like this "P:\Spreadsheet Project\Testfolder\04_" & myVar" Can anyone assist me with the code to open the folder...

Hi Thanks for your help but I have decided to protect the sheets and unprotect them when required. Jo

Hi, I have some code which creates a new folder and copies a workbook into it. The original copy of the workbook is Read Only, defined by the properties and not passwords. The problem is that when I copy the workbook to the folder it looses the Read Only protection. How can I ensure that this...

Hi I have a workbook which is in a public domain for people to view as Read Only (no passwords involved). I need the same people to Write information to the workbook via an input form. I have designed a button which will open the workbook and display the inputform, but need to know the code...

Thanks Golom Have just tried your code and works great! Jo

Hi I need to go to the last entry in a column and use this as myVar. I then need to check if a folder exsists with this name, and if it does not, create one. Then move up the list until I get to the point where the variable does exist within the folder name and exit. I have managed to do...

I am working on a worksheet where I want to check what is entered in cells c2:c49 and if that is = "ADMINISTRATION" an event occurs. In column F is a start time, in column G there is a finish time and in columns H & I there is a formula to work out the actual time spent doing a...

Hi I have two problems 1. In the first textbox of a userform I need a date to be entered. the format of this date has to be dd/mm/yy. How do I stop anyone from entering dates in any other format i.e. dd.mm.yy etc? I had tried using a Combobox and validating the cells from a list in the...

Ok, The solution I uesed was filecopy "P:\Spreadsheet Project\Time\Trial Sheet.xls", "P:\Spreadsheet Project\Testfolder\04_" & myVar & "\Trial Sheet.xls" Where myVar was the variable data used to create the unique folder name. Jo

Hi, Thanks for your help but I have solved this now. Jo

Hi I tried the above code but came up with a compile error as expected:end of statement. Do you have any suggestions? Thanks Jo