|
|
|
|
#1
02-01-2022, 03:59 PM
|
||||
|
||||
It should be possible to set up a class for your ActiveX controls so that you don't need to create a set of Subs for each one. If you do a search for Class Modules you should be able to find the information you need to set this up correctly.
Here are some relevant links that will either give you the answer you need or show you the relevant keywords to do a better focused Google search Textbox Class Object - TIP, TRICKS & CODE - OzGrid Free Excel/VBA Help Forum Return active OLEObject in Worksheet - Excel General - OzGrid Free Excel/VBA Help Forum Using change event of multiple ActiveX controls with no userform using class method - Excel General - OzGrid Free Excel/VBA Help Forum
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
| Tags |
| activex control, textbox, undo |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Event macro: insert row with formulae based on current row, clear selected contents | emsa | Excel Programming | 5 | 04-17-2020 09:03 AM |
 How to track changes in a ActiveX Textbox
|
tommasorossotti | Word VBA | 1 | 02-24-2020 03:57 AM |
|
ActiveX Textbox properties using VBA
|
kyeung | Word VBA | 5 | 10-05-2015 12:47 AM |
|
Display result in textbox based on the input of another textbox
|
scarymovie | Word VBA | 5 | 05-16-2012 07:05 PM |
| How to insert a hyperlink in activex textbox | Joe Patrick | Word VBA | 1 | 10-03-2011 06:03 AM |
Windows 10 
Office 2016
Hybrid Mode