Excel 2007 macro not working in Excel 2024 Now Resolved

[smiler44]

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

 

[The_Doc_Man]

Between 2007 and 2024, Office structures changed internally in a way that required use of more (and different) libraries. Get to a VBA page and check Tools >> References to see if you are listed as having a missing or broken reference.

 

[smiler44]

oh, sorry I think I have this one. It was a setting that I have already forgotten, my mind is so worn out, I think about security and allowing something to run with I think notifications.

With that sorted and now knowing how to use the F8 key things are looking good. I need to change the file path that the VBA is using as this is wrong but that is something I can work out and change.

Thankyou The_Doc_Man for the help.

smiler44