Vba activate grid control as additional control
I want to add control to user GUI that would represent excel like table but I cannot find additional control that would do that. Control like that would be used for easier data entry.
I believe that VBA has control like that and I am missing something obvious.
Does anyone know where to activate control like that?
Solution
If you have VB6 installed then, this should work:
However, if you do not have (vb6) then, another option is to create one yourself by dynamically adding controls to your UserForm (such as a textbox) and then tracking those object. It would take some work, but it would be an option.
- TextBox and Listbox in Excel Vba
- What is wrong with the variable?
- VBA Speeding Up Index-Match for Large Dataset
- Excel select cells within filtered cells
- Excel VBA ClearContents Dynamically
- Trying to send screenshot of excel in an email
- Stopping Excel Macro executution when pressing Esc won't work
- How to use VBA to change the default MS Word 2016 options so that when you save as PDF the headings are included as bookmarks?
- Excel VBA search for data and stuck at a certain point due to group or split source file?
- Convert Time Input in Decimal Format - Excel Formula or VBA
- Lookup unique "Values" if they follow a certain "Pattern" from a lookup table then return a "Name"
- How to apply ItemAdd event to a subfolder
- How To Close a UserForm Properly in Excel VBA?
- In Excel, can I use a hyperlink to run vba macro?
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- Split too large VBA into multiple Subs
- How to disable access security notice "A Potential security concern has been identified"
- Copying a String Array into a Range of cells (in MS Excel using VBA)
- Access VBA MSHTML document with scripts loads slowly
- Is there a way to create formula in Catia via Macro to link parameters?
- Problems using a C++ Dll with Excel 2016 32bit
- How to extract R InstallPath from Registry using Excel VBA
- More efficient way to loop through lines and duplicate if a certain character is found
- Excel List Parse Table
- Normal.dotm equivalent in Excel for referencing the same single VBA code
- What Run time error in an SQL Query for join means
- Create A Chart On Each Worksheet Using The Data From That Worksheet
- Userform with Excel 2018 for MacOS
- Extracting digits from a cell with varying char length
- Grouping dates from rows