Questions about excel-2016
Read more about excel-2016
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
How to read/set Excel Textbox property from MS-Access VBA
I have a simple Textbox in Excel worksheet (.xlsx) where I can read the BackColor property in Excel VBA sub with:
Debug.Print TextBox1.BackColor
I'm trying to reference that same textbox from MS-Acce...
dbmitch
Votes: 0
Answers: 1
Find all code combinations using text string in Power Query
What I need is to find all the code combinations from Codes (table 1) using text string (long text string in A2) and to get all the combinations like on the Results table (table 2). For instance, you ...
MmVv
Votes: 0
Answers: 1
Microsoft Excel 2016: MINIF function not working when copied down column
I am using the following formula in cell H2 to calculate the minimum temperature (column C) each month. Column C shows every temperature observation taken at 3-hour intervals throughout the month spec...
J Clifford
Votes: 0
Answers: 0
VBA Error No Such Interface Supported (I am using MS Access app to manipulate excel files/data
I am using an MS Access App to manipulate files. The gyst is I want to loop thru all folders and subfolders, open each workbook and if the mastersheet tab exists, delete it. If not, create it. Work...
OriginalStealth
Votes: 0
Answers: 0