Search results

I could be back with lots of questions having gone from Excel 2007 to Excel 2024 Excel 2007 vba code, sheet1.textbox1.value = "1:30:00" Excel 2024 does not like .textbox1 What should it be? thank you in advance smiler44

just noticed I have posted this in an Access group. Also noticed i may have worded the question wrongly, the text box is an active x control I will create a post in the excel group, sorry smiler 44

I have a macro created on execl 2007 and have moved the workbook to another laptop running excel 2024 If I use the F8 key to step through the code it takes me to the desk top screen and locks the laptop. How do I make the F8 key step through the code or is there a different button to use...

For the macro to run, would I not have had to enable macro as I would do in Excel 2007? In the code page I have a message, Compile error : method or data member not found I just tried to record a macro to a new workbook to see if I can see the code but when I try to insert a text box, I get...

I could be back with lots of questions having gone from Excel 2007 to Excel 2024 Excel 2007 vba code, sheet1.textbox1.value = "1:30:00" Excel 2024 does not like .textbox1 What should it be? thank you in advance smiler44

:), thank you. The problem is resolved and the folder has gone. I meant I could not start writing that sort of code just like that. I have forgotten it all, sorry if I confused you. Thank you for helping smiler44

My goodness, it has been years since I saw code like that. Used it with Visual Basic perhaps or Excel macros. I would have no idea how to write code now. smiler44

just an update and to say thank you. I had tried to move the folder into the documents folder but this failed or so I thought. I went to try and add another folder and make it a sub folder of the folder I cannot delete. I noticed the folder I wanted to delete had moved into the documents folder...

How do I run in safe mode? smiler44

sorry yes it is, should be C:\Users\sagen\Documents it does not have an \ and the actual folder name when i right click and look at the properties. smiler44

Thank you, just tried the right click on the drive and then tools and error checking, nothing found. A question, if I right click on the C drive in the file explorer, could changing any security settings help? listed are Account Unknown, Authenticated Users, SYSTEM, Administrators, Users...

I have not tried and to be honest, it is not something I want to try as I could end up with another folder I cannot delete. If that becomes th very last option I will reluctantly try, sorry smiler44

I have no idea what information if any I am not telling you. I am open to any ideas of what I may be forgetting or not thinking to mention. smiler44

Hi The_Doc_Man, thank you for your post. In order 1. I right clicked the file, choose security and got the message The requested security information is either unavailable or cant be displayed. I tried it on the documents folder above, there are 3 things listed, system, Administrators and a...

I am a novice I created a folder in windows 11, the path shows as c/users/sagent/documents/music but when I click the documents folder it is not there. Opening the documents file explorer I can see the folder below a folder marked Microsoft office. There does not seem to be any option, right...

Ok, thank you. I would still expect a drive letter to appear which is what a USB stick does. I have just tried putting a CD in and blow me down, the CD writer now appears in the Explorer window, thank you very much The_Doc_Man. I will probably be back with many more seemingly daft questions but...

I have an LG GSA-2164D usb DVD/CD re-writer but it does not show in the File Explorer list of Windows 11. It does show if I go to Device Manager and then click DVD/CD-Rom Drives. How do I get it to show in the File Explorer list ? Should it show in the File Explorer list? Thank you in advance...

thank you pbaldy, currency has worked. I never knew integer could not deal with decimals. smiler44

I have a macro comparing the value of two cells next to each other but 39.99 is being rounded up to 40 and 33.17 rounded down to 33. I have no idea why or how to cure it, please can you advise? Below is my code and it is Excel 2007 thank you Dim rt As String ' number of times Dim ev As Integer...

thank you both, for some reason I did not get a email notification. I think I will need to put "that" formula in a cell in each row, is that right? Is there a way to put a formula in one cell and it do all the work, there could be 800 rows? smiler44