Edit: Most responses so far involve checking for possibly non-existent objects, which outright does not work in VBA with Option Explicit on (it throws a compile-time error, so On Error doesn't work, and turning off Option Explicit is not an option). Is there some other roundabout / out-of-the-box way to...
Problem StatementIn VBA, three main kinds of date time controls can be used provided certain ocxs have been registered using administrator rights. These are VB6 controls and are not native to VBA environment. To install the Montview Control and Datetime Picker, we need to set a reference to Microsoft MonthView...
Unlike in VB6, there exists no native calendar widget in VBA. The only widgets I can find are very environment-dependent; they require registering mscal.ocx or mscomct2.ocx and so only work with 32-bit versions of Office.
I am relatively new to VBA. I am trying to write a code for nested IFs in VBA. I have the following code, yet the output is wrong. How can I make the nested if function work?
the following numbers begin in cell B5: 23 34 45 56 45 54 I want to sum the first digit of each, and display the result in cell C9
i'm trying to write a test module to test one of the modules I wrote in VBA. In specific, I have a if statement I would like to trigger using the test module by giving the module/funtion the wrong initial parameters. The module/function I would like to test is:
I am developing a small tool using Delphi Pascal to open an XLSX file, and write a cell on it. It behaves differently on a machine using Office 2013 and Office 365.
I have an Excel Sheet with about 4500 checkboxes (I know, it sounds stupid, but it is for a customer, please do not ask...). Just wrote the VBA Sub below to uncheck all the boxes together. So far it works, but it is terribly slow, it takes more than 5...
Often times it's required that you go through a range of cells, and based on some criteria, delete an entire row.
I've been trying to convert a cell in VBA which is like this:I am 99 years old and I was born in 1918.