Search results for query: *

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, 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...

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...

Hi I need to create and change the name of a folder based on the information contained in a specific cell or cells on a spreadsheet. I can create the folder, but need some help in re-naming it. Can anyone help me out? Thanks Jo

Hi Does anyone know a formula which will convert a time which is hours and minutes to just minutes? ie 1:20 to 80 Thanks Joanne

Hi I am trying to copy data from one sheet to another using VBA. However when I have copied the data and move to the sheet I want to paste into I first have to find the first blank row. When this has been done and I ask for the data to paste it has dissappeared. Does anyone have a solution...

A date is input into a userform and when transferred to the spreadsheet it americanises. This is regardless of cell validation and regional settings. Can anyone advise a solution to ensure the date enters in the UK way? Thanks