Search results for query: *

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

Hi Mike I have two buttons on a toolbar the code is below. the var flag is declared as public on a seperate sheet. Sub addentry() flag = 0 Checkers.Show End Sub Sub editentry() flag = 1 srow = ActiveCell.Row erow = srow Checkers.Show...

Hi Here is my code. What should happen is that when the editentry button is selected data from the spreadsheet should fill the form. the first time it doesn't, when I cancel and try again all is fine. Any ideas would be good. Thanks Private Sub UserForm_Initialize() If flag = 1...

Hi I have created an Excel Workbook that I populate by a form created in vba. Within this form have combo boxes that are populated when the form is displayed. I have two buttons one is to add an entry and the other is to edit entry. The edit entry button picks the data from the specfic row...

Hi Can anyone help! I have put some hyperlinked email addresses into a word document and when I click on the link the hyperlink changes colour. Is there any way that I can stop this from happening and leave it still highlighed in blue.? Thanks David Regards David

I have a user that has some how changed the views on all her folders so that the Subject field is missing. when new folders are created the subject is also missing. She does not know how she has changed it. I can put the field back in manually but does anyone know hgow to do it for all the...