Recent content by turps

Thanks for this. The spreadsheet had been set to hidden. Once I unchecked this it worked find. Regards David

Hello I have a spreadsheet worksheet that needs to be protected but that allows the user to use the find function. With the WS protect and they use the find option they get the message "Microsoft Excel cannot fing the data you're searching for. Check your search options, location and...

Thank you all for your help [Thumbsup] Regards David

Hi I have got it to work by deadlinetime = Right(txtDeadline, 5) Cells(srow, 5) = DateValue(frmCheckers.txtDeadline.Text) & " " & deadlinetime Regards David

Hi I have a form that allows the use to click on a button to input the date and time. This then needs to be added to a worksheet and need to display the date and the time within the same cell. Using the code ActiveSheet.Range("A1").Value = DateValue(txtDate.Text) this works with the...

Sorry posted my reply before I read your replies. Regards David

Hi deadlinetime = Right(txtDeadline, 5) Cells(srow, 5) = DateValue(frmCheckers.txtDeadline.Text) & " " & deadlinetime I have just got this to work for me. But if anyone has any other ideas. PS what is implicit adding? Regards David

ActiveSheet.Range("A1").Value = DateValue(txtDate.Text) Regards David

Hi all This thread has been very helpful with regard to the date within VBA. But I need a little more help. I have a form that allows the use to click on a button to input the date and time. This then needs to be added to a worksheet and need to display the date and the time within the same...

Thank you Geoff for your answer. I have used sheet activate code to select the current months sheet. Regards David

I have a lot of vba code within the document. I thought that this might be the problem. Saying that I have a number of spreasheets that also contain code but none of these have the problem saving. Regards David

Hi Thanks for your posting. I have had a look and it is aready set to Excel Workbook. Any other ideas? Regards David

Hi Does anyone know why when I save my excel file it goes through the process of saving twice? Any help? Thanks Regards David

Hi Skip I have tried this and it still does not pick the data up the first time. Regards David

I would love to use access or some other DB system to create it in but I have to work with what we can use. The reason that I use different sheets is on average each mth about 1500 rows of data are added. Having it in one sheet would make it very unuseable for the people in my office. Any...