3,809 questions
Score of 2
2 answers
135 views
VBA Userform Listbox click event issue: listbox will not "clear selection" when new items are added
I have an issue with the VBA ActiveX Listbox control.
When I click an item from the listbox, I want the listbox to get the item, clear the the whole listbox, and then add new items.
But, except from ...
Score of 1
0 answers
156 views
I'm getting this error message in my VBA code
I am getting an error "DOB Error:" shown in my code's error handler, and I am unable to fix it.
Please help me; this code is mostly used to validate a date available on a web page, and if ...
Score of 0
4 answers
99 views
Integrating Windows Explorer as a control in Windows 11
Is it possible to integrate Windows Explorer component as a control, created on my window? For instance, as an ActiveX control. It should work in modern Windows 11 (24H2, 25H2).
Back in Windows 9x ...
Score of 0
0 answers
118 views
How to pass null as ActiveX control parameter
ActiveX control was registered from dll file using regsvr32:
cd \windows\syswow64
regsvr32 "C:\mapp\mycontrol.dll"
FoxPro object is created from it using
ofiscalprinter=CREATEOBJECT('...
Score of 0
1 answer
139 views
PPT Presentations.Open changed from Version 2508 (Build 19127.20192)
I have a problem with calling PowerPoint's Presentation.Open method.
It seems to me that the Untitled parameter to
Presentation.Open
has changed.
When opening the same file twice (once with Untitled:=...
Score of 1
1 answer
167 views
Adding a photo from ActiveX to an Outlook email attachment using VBA
I am fairly new to VBA and am using a userform to let colleagues upload a photo which then gets pasted into an ActiveX photo box on my Excel spreadsheet. From here I then attach the complete form as a ...
Score of 2
2 answers
158 views
Using ActiveX Checkboxes Conditions to Check or Disable Another Checkbox AND to Populate Column
Fair warning I'm very new to using VBA and I've looked all over this site but I can't seem to a similar question.
I'm hoping it's a pretty easy solution though.
I have these checkboxes 1 - 4
Example ...
Score of 0
1 answer
142 views
Microsoft Word ActiveX Checkbox VBA code to change fill color of table
New here and not a coder in the least. I know virtually ZERO about coding, so be easy on me if this is a super dumb question.
But here is what I am wanting to do:
I have a very long checklist in ...
Score of 0
0 answers
155 views
RDP Client - AxMSTSCLib.AxMsTscAxNotSafeForScripting Resolution Setting
Using the component axMsTscAxNotSafeForScripting..
How can I set the resolution of the remotely reached server?
My screen is set to a high resolution.
Can I set the remote server to a fixed resolution ...
Score of 0
1 answer
96 views
VBA Option Buttons Clearing for Unknown Reason
I’m building off a workbook someone created years ago where Sheet 1 has primary equipment info entered into ActiveX text boxes and option buttons, with matching ActiveX controls below it for secondary ...
Score of 1
1 answer
78 views
Excel automatically renames back ActiveX controls when reopening XLSM spreadsheet file
I had added an ActiveX control (in my case, it was a ComboBox, but it might as well be a button or something else) to a spreadsheet, and named it Analysis1_FileAction_ComboBox. Later I renamed it to ...
Score of 0
0 answers
63 views
How to propagate ActiveX checkbox values from .xls or .xlsm to .xlsx in locked-down environment?
This is probably futile, but I have a scenario where some customers are using older versions of an Excel spreadsheet form in .xls or .xlsm format with ActiveX checkboxes. I've tried to get them to use ...
Score of 0
3 answers
342 views
Is there anyway to determine whether a dll is an ActiveX control or strictly a COM object?
I am currently working on a legacy project requiring me to identify ActiveX controls from a group of DLLs and OCXs. However, I find that the terms "COM" and "ActiveX" are almost ...
Score of 0
1 answer
233 views
Cannot create ActiveX component after upgrading Office
A customer has recently had their Office software upgraded to Office 365 and now the bespoke software they use will not send e-mails, instead they get the error "Cannot create ActiveX component&...
Score of 0
1 answer
91 views
Python pass string ref into method of COM (ActiveXCtrl)
I am trying to use a method present in an ocx file.
The definition of this method is (resolution from VS - c#)
VS Screen
[DispId(17)]
[MethodImpl(MethodImplOptions.PreserveSig | MethodImplOptions....